Hi,

I'm trying to write a macro to capture a variable range,
and the relative reference function I keep seeing is using
Offset. I don't know if it's three rows down or 300.
What is the VB syntax to select end over and end down to
capture the entire range of data? Thanks.

Michael Bulger

LastrowA = range("A65000").end (xlup).row


--
....Patrick
Quoi que vous fassiez, faites le bien .
Mail: http://cerbermail.com/?KPW0tTCjFw
Connectez vous sur ce forum par :
news://msnews.microsoft.com/microsoft.public.fr.excel



"Michael" a écrit dans le message de
...
Hi,

I'm trying to write a macro to capture a variable range,
and the relative reference function I keep seeing is using
Offset. I don't know if it's three rows down or 300.
What is the VB syntax to select end over and end down to
capture the entire range of data? Thanks.

Michael Bulger