Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Determining used range, selecting and copying

  Asked By: Anpu    Date: Nov 29    Category: MS Office    Views: 800
  

I have a workbook with multiple worksheets, each with data in them. What I want
to do is select the UsedRange in each worksheet, copy it, and then paste it into
a different worksheet. With each loop through each subsequent worksheet, I want
to paste the current copied data at the bottom of where the previous worksheet
paste ended. All worksheets have the same number of columns, but can be a
different number of rows.

To add to my problem, on some worksheets there are a few extraneous cells of
data a few rows below the end row of what I want to copy & paste. Therefore,
simply selecting the UsedRange won't always work - I have to select all rows &
columns until I reach a row in column A that is blank.

I haven't even started writing any code for this piece of the project yet, so I
have no example to post. If somebody could give me just a few snippets of code
I think I could build from there. The biggest part of this would be to just
select the main rows & columns down to the first blank row, and I think I could
take it from there.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Determining used range, selecting and copying Or get search suggestion and latest updates.




Tagged: