672 reputation
1513
bio website
location Seattle, WA
age 32
visits member for 5 years, 2 months
seen Nov 12 at 21:56

Dec
27
answered Excel Number Formatting - not to be carried into copied cell
Dec
27
answered Grouping Excel graph categories
Dec
18
comment Why Excel doesn't ask(prompt) to Save the file which is modified while closing
I have a feeling it got downvoted because you failed to mention in the question that you had code at all, let alone code that got rid of alerts. Or, that it may be a duplicate as indicated by another comment on your question. Always going to get downvotes if there are other questions out there with answers. Part of the SuperUser experience is that people really like those who have done homework and ask specific questions rather than present very vague issues.
Dec
18
comment Why Excel doesn't ask(prompt) to Save the file which is modified while closing
There is a method to return them to normal. You reverse your original code. There is no return all, because one person's "normal" is not going to be the same as another's idea of normal.
Dec
17
comment Why Excel doesn't ask(prompt) to Save the file which is modified while closing
Excel has a number of defaults built-in, including the display alerts. Once you code something that changes that default, it will not revert unless you tell it to. That is what you want to have happen. If it didn't work like that, programmers would have a difficult time finding out why their code wasn't working. Recap and General rule: if you turn it off, turn it back on (and vice versa). And don't forget to turn things back on, even when there is an error that stops normal execution of your code.
Dec
17
comment Is there a macro to filter table by some list elements?
If you are using excel 2010, you can set up autofilter, and it has a new text box option to look for the text you want (instead of just having the text boxes). So you can now type test1 and filter to all cells that have test1 in them. If you wanted something a little more user friendly you could record yourself doing that then use the resulting macro to create the options you are looking for.
Dec
3
comment How can I edit this macro to loop through the results?
Chip Pearson can explain this better than I Chip Pearson - Find All Function
Dec
3
comment VBA to sequentially number rows in column
Your code worked for me. What is it not doing for you?
Dec
3
answered VBA macro in excel 2010 32 Bit mode
Dec
3
answered Formula to search highest value related to a near match reference
Dec
3
comment Excel Combo box to filter a table column
Or if you are using a filtered table, you could use the built-in drop-down. It expands the list in the drop-down automatically based on what is in the table.
Dec
3
answered Dynamically updated floorplan/asset register in Excel
Nov
26
answered Pick data from another sheet in specific row intervals
Nov
22
comment Excel Macro looping
Are you calling this macro from a workbook event? If not, how is it getting called?
Nov
19
comment What is the Windows equivalent of this Mac Excel shortcut?
That's crazy. To my knowledge there is nothing built in, but it could be programmed via VBA to do something similar. Oddly enough, these shortcuts are not listed on the Microsoft site for the Mac version of Excel.
Nov
18
comment What is the Windows equivalent of this Mac Excel shortcut?
what do you mean by "move the selection to the right"? You mean if you select A2:B2 and you press option-tab then the selection will be B2:C2? Can you give some examples? I'm sure we can find it for you.
Nov
18
comment Excel Multiplication
While what you want seems clean, it is actually cleaner to show your calculation. It doesn't have to show on the same sheet though. I will often use 1 sheet for data entry, then another to show the results of my calculations in the format that I want.
Nov
18
answered Parsing Date/Time Formats in Excel
Nov
15
comment Graphing Two Lines as if they are the Same
X shouldn't be a series, it should be the labels...
Nov
15
answered 2 Monitors 2 Excel Sheets?