Autoselect range

[WK]

All columns and rows are filled with data. How do all automatically
select the range using a macro so that I can copy it out to other
worksheet?

 

[Guest]

If A1 is in your range:

range("A1").currentregion.copy

If not, replace it with a cell that is.

Or, just click on a cell in your range before running the macro for this:

selection.currentregion.copy


tj