Macro to advance current row by 1
 

Hi

You can't change the activecell when the Sheet is not Active.
But for most things you don't have to select.

What are you trying to do?

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Dan" wrote in message ...
I would like to create a macro that can be attached to a button on Sheet2 that when clicked will cause the Active row in Sheet 1
to advance by 1.

Thanks in advance - Dan