375 reputation
314
bio website
location Hamilton, Canada
age
visits member for 3 years, 8 months
seen 21 hours ago

About me:

I fix things (hardware, software, processes).

I ask questions (early revisions are more cost efficient).

I devote myself to doing projects right (no use cutting corners when it might have to be redone).


Sep
24
awarded  Autobiographer
Jul
2
awarded  Curious
Mar
17
awarded  Popular Question
Oct
5
awarded  Notable Question
Aug
16
awarded  Popular Question
Apr
25
awarded  Enlightened
Apr
25
awarded  Nice Answer
Dec
18
comment How to replace cell formula with its own value via UDF?
Thanks! I guess that will have to do. I was hoping to put the UDF in an excel addon (.xlam) so that it would be available on all worksheets, but I guess that's not possible.
Dec
18
comment How to replace cell formula with its own value via UDF?
Thanks, but I was wanting to do that from within the UDF (please read my question more carefully).
Dec
18
accepted How to replace cell formula with its own value via UDF?
Dec
17
awarded  Yearling
Dec
17
revised How to replace cell formula with its own value via UDF?
added 64 characters in body
Dec
17
asked How to replace cell formula with its own value via UDF?
Dec
14
awarded  Critic
Dec
13
comment Pressing down arrow jumps to top of Excel spreadsheet
Thanks for the answer. I would be ok with excel jumping to the top once it got to the bottom of the sheet, but it is jumping prematurely. For example: In the link you posted, you have 3 sections (A and D are unlocked, and section C is locked). The behavior I am experiencing is that using the keyboard arrows, the selected cell would cycle through all unlocked cells in section A, and then instead of jumping over section C to section D, it would start back at the beginning of section A. The only way to get to section D is to use the mouse and click.
Dec
12
comment Pressing down arrow jumps to top of Excel spreadsheet
@JMK Ok. Is there a way to migrate it to SuperUser?
Dec
12
asked Pressing down arrow jumps to top of Excel spreadsheet
Oct
2
comment Excel Formula: What is the equivalent of =MATCH(), but for multiple columns?
Brilliant!! Thank you SO much. It worked like a charm. The only thing I added was $ around the lookup arrays so that they wouldn't increment when I auto-expanded the formula.
Oct
2
accepted Excel Formula: What is the equivalent of =MATCH(), but for multiple columns?
Oct
2
revised Excel Formula: What is the equivalent of =MATCH(), but for multiple columns?
fixed title