auto run macro

[scancool]

I'm trying to create a macro that would read the data from A1 every min and would posted to A3 and the next min would post on A4 and so on, cause I'm capturing A1 data from the web and it changes every min, so I would like to keep a record of it.

I created this macro

Please Login or Register  to view this content.

how can I make it to auto increment

[HaHoBe]

Hi, scancool,

as long as the scope of the procedure doesn´t end you may use something like

Please Login or Register  to view this content.

Or use a public variable, a range to which to write the rownumber that had been filled, use a name fro that, write the row number to a textfile, just to name a few more options.

Ciao,
Holger