Reputation
5,852
Top tag
Next privilege 10,000 Rep.
Access moderator tools
Badges
7 32 69
Impact
~1.7m people reached

Mar
29
awarded  Notable Question
Mar
25
comment Shortest Method To Reference A Single Row/Column of a Named Range in Excel?
@whytheq, My guess would be that for large columns Max("A:A") would be the most efficient. You could time and test, see here: stackoverflow.com/questions/198409/….
Mar
24
awarded  Enlightened
Mar
24
awarded  Nice Answer
Mar
23
awarded  Nice Answer
Mar
21
awarded  Necromancer
Feb
10
awarded  Famous Question
Jan
8
answered Restoring sheet size closes workbook
Jan
8
comment Restoring sheet size closes workbook
@Raystafarian, I finally found a good link that talks about the problem and I can now at least make the sheet reappear, though I have to do it every time. I'll post an answer when I get a chance to completely go through it. smurfonspreadsheets.wordpress.com/2009/03/17/…
Jan
8
revised Restoring sheet size closes workbook
added 116 characters in body
Jan
8
comment Restoring sheet size closes workbook
@Raystafarian, didn't do it. It gets more interesting though. I've found that the workbook is still open, and I have a formula selected in the formula bar, but there is nothing to see. I went to the immediate window and it said that the Workbook was Visible. editing question.
Jan
7
comment Restoring sheet size closes workbook
Yes, plenty of code behind. I've tried everything I could find, too much to list (or remember). Checked all the settings and played with sizing.
Jan
7
comment Restoring sheet size closes workbook
Yes, the restore button in regards to sizing. Yes, I'm referring to the Excel workbook, not Excel. The only ActiveWindow commands are .SelectedSheets.Printout, .ScrollColumn and .ScrollRow.
Jan
7
asked Restoring sheet size closes workbook
Dec
7
awarded  Self-Learner
Nov
11
awarded  Notable Question
Nov
4
awarded  Revival
Jul
16
awarded  Yearling
Jun
19
comment Adding a date to a formula in excel
@fixer1234, nevermind, it actually can get complicated since there is no ISDATE function in Excel, but we just don't have enough specs here to be sure what the OP is asking.
Jun
19
revised Adding a date to a formula in excel
added 297 characters in body