Question Locked
Macro query
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
All
I am trying to get a macro to input "Yes" against a variable cell.
The "Yes" will always be in Column AJ, but the row changes (as users input data).
The macro i have is:
Range("A5").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 30).Range(A5).Select "Yes"
Range("A5").Select
However, this does not work. I am new to macros, so would appreciate any pointers in what i am doing wrong.
Thanks