Running below code while on Sheet1. In blue line below need to somehow make a reference to Address of Range("A" & (ActiveCell.Row)).Value rather than to currently active cell:
Replace Address of currently ActiveCell with Address of "A" & (ActiveCell.Row)
-
acat -
January 31, 2019 at 9:16 PM -
Thread is marked as Resolved.
-
-
-
-
No, that's not it. You didn't take into account the Address part
-
No, that's not it. You didn't take into account the Address part
Don't mention it. Why are you asking a question if you know the answer?
-
Currently the blue line in my code above refers to a cell on different Sheet with same address as active cell. Objective is for it to refer to a cell on different Sheet on the intersection of Column A and same row as active cell on active sheet.
-
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!