using a macro to automatically select a varying range of data

[psimon1]

Hello-

I would like to record a macro in a CSV that automatically selects all of the data in a sheet. I know how to do this with a range of standard length and rows. However, the rows in my sheet will vary each time. I know about the control + arrow down trick to get to the last line of data but that still doesn't select it. It just brings me down to the last line.

Any help would be surely appreciated.

Thanks.

ps

 

[Tiglet]

Does CurrentRegion.select work?

 

[psimon1]

Thanks for the response.

CurrentRegion doesn't ring a bell. I wasn't aware of it.

My data have blank columns unfortunately, not by my design. Would this confuse CurrentRegion?

It's a moot point, I figured out how to specify importing specifications in Access (where it needs to go anyway).

Thanks.

ps