Copy Current Region

  • Thread starter Thread starter Rohit Thomas
  • Start date Start date
R

Rohit Thomas

Hello All,

I have used the following code to copy data from one
worksheet to another when I do not know the exact range
but always start at Range("A1"):
Range("A1").CurrentRegion.Copy

However, this does not work if one of the columns in
between the entire range has no data. How do I copy the
entire range if one or more columns in the range contains
no data?
 
Back
Top