Unexpected results from CurrentRegion

I have a workbook with many worksheets. The range of the worksheets is always A33:[any number of columns wide]33. What I need to do is copy the contents of each worksheet into a single worksheet, with each set of data appended to the right of previous.

Here is the portion of code I am having problems with:

Please Login or Register  to view this content.

It functions exactly as expected, however CurrentRegion does not seem to grab the proper area from all worksheets. Despite this, when I test the code in the immediate window the selection is exactly as I would expect.

Thoughts?

What do you mean by the 'proper area'? The current region is what it is. If you have blank rows and columns they will not be included.

Originally Posted by snb

Please Login or Register  to view this content.

Thanks, that seems to have done the trick.

I'm a little confused as to why this works as opposed to the previous method. What is the difference between using cells(1).CurrentRegion and Range("A1").CurrentRegion?