cleaner code

[scancool]

I created this macro that copies from cell A1 and paste into the next cell I want to keep incrementing but I dont want to keep copy and paste the same thing how can I make it cleaner, with out having next_1, next _2 , next_3 and so on

Please Login or Register  to view this content.

I had it before every 10sec just for testing,

[mike7952]

Not sure maybe this?

Please Login or Register  to view this content.

[shg]

In a standard module:

Please Login or Register  to view this content.

In ThisWorkbook:

Please Login or Register  to view this content.

[scancool]

thanks mike, but that fills up from a4 to a8 with the same thing at once, the data from A1 change every min, thats why the timer check on A1 every min and copies in the next cell, this works I just want to make it cleaner so I can go up to 100

[scancool]

THANK YOU SHG!!!!!!!!!!!! it works!!!!!!!!!!!!!!!!

[scancool]

I feel kinda embarrassed to ask, but I been trying for a while to add the time stamp on the A column for every print with no luck, how can it be done ? I had put =now() on A3 cell and change Range("A3:D3") but it copies the now() so the time is the same for every row

Please Login or Register  to view this content.

Clipboard01.jpg

[shg]

Please Login or Register  to view this content.

[scancool]

Thank you SHG
I keep trying after I posted yesterday, and came out with this code

Please Login or Register  to view this content.

but yours seems better

[JBeaucaire]

If that takes care of your original query, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

[shg]

A little better:

Please Login or Register  to view this content.