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?