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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Want code to copy to ABOVE row 22 column A on sheet 1 10
Copy columns and paste with blank column between 5
Code copies between key word is in reverse order 5
Copy Array to Array, how to and should I? 13
Ron de Bruin - Merge cells from all worksheets 0
Copy FROM - TO Object/Block variable not set 6
Excel 2013 Merge Data 2

Back
Top