G
GatheringShadow
This is a question that may or may not have been addressed, but I'v
been looking for answers for a while and can't find any. Frankly, it'
driving me crazy. So, here's the question.
I created separate macros to initialize values for three cells i
Excel. The reason I did this is because they each refer to cells i
relation to themselves, so one macro won't work. Now I am trying t
select a row (or the first cell in the row) to have one macro activat
all three. However, the macro only references the row I recorded th
macro on, not any other row I may select. I've tried four or fiv
different ways to edit the macro (both after recording it or simpl
starting cold). Nothing seems to work. Can anyone help me t
reference cells in a macro, based on the starting row or cell?
ex. Row 12 is selected. A12 should execute Macro1, B12 Macro2, an
C12 Macro3
OR
Cell A5 is selected. A5 is Macro1, B5 Macro2, and C5 Macro3
Either way is fine with me, either selecting the first of three cell
or the entire row. Thanks for any help you can give me.
New excel, old programmer...
been looking for answers for a while and can't find any. Frankly, it'
driving me crazy. So, here's the question.
I created separate macros to initialize values for three cells i
Excel. The reason I did this is because they each refer to cells i
relation to themselves, so one macro won't work. Now I am trying t
select a row (or the first cell in the row) to have one macro activat
all three. However, the macro only references the row I recorded th
macro on, not any other row I may select. I've tried four or fiv
different ways to edit the macro (both after recording it or simpl
starting cold). Nothing seems to work. Can anyone help me t
reference cells in a macro, based on the starting row or cell?
ex. Row 12 is selected. A12 should execute Macro1, B12 Macro2, an
C12 Macro3
OR
Cell A5 is selected. A5 is Macro1, B5 Macro2, and C5 Macro3
Either way is fine with me, either selecting the first of three cell
or the entire row. Thanks for any help you can give me.
New excel, old programmer...