I have a list of file names in Col A. Before running my macro for the first time, I select Cell A1, and it inserts a comment in C1
Once the macro has run I want it to the cursor to be on A2, then after running the macro select A3 etc
The code that inserts the comment in Col C is as follows:
It tried using the code below, but get a run time error
It would be appreciated if you someone could kindly assist me
Once the macro has run I want it to the cursor to be on A2, then after running the macro select A3 etc
The code that inserts the comment in Col C is as follows:
Code:
rng.Offset(, 2) = "workbook mailed"
It tried using the code below, but get a run time error
Code:
ActiveCell.Offset(1, -2).Select
It would be appreciated if you someone could kindly assist me