Easy One

[hamilj03]

Ok, I have an easy one for you, but I cannot figure it out. I need a macro that copies a cell in the L column then paste it back to that same cell, then move down to the next row in the same column. I need to do this to trigger a change of existing data to trigger another VBA program. Any help would be appreciated.

 

[Smitty]

Welcome to the Board!

Have you tried the macro recorder?

I need to do this to trigger a change of existing data to trigger another VBA program

Are you using a Change or Calculate event?

 

[hamilj03]

I am actually using both.

I am using the calculate to apply formatting to the row and change to add the date that some data was changed.

I tried to use the macro recorder but wouldn't I have to go through each cell to record it. That would be over 2000 cells.

 

[hamilj03]

I tried to record a macro that would step down but could not get it to work.

 

[lenze]

So, are the cells changed by the user or by a formula?

lenze