Autoselect range

W

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?
 
T

tjtjjtjt

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
 
Top