Question

Locked

Macro query

By eddie.rodgers ·
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

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Web Development Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums