Hi,
I believe CurrentRegion is based on the first cell of the range object, i.e.
mySourceRange.CurrentRegion in fact does
mySourceRange.cells(1).CurretRegion
That is, even through mySourceRange contains 100 rows of data and 20
columns, if the second row is blank, CurrentRegion returns the first row only.
Are you in this case?
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Barb Reinhardt" wrote:

Let's try this again.

I have the following code:

Set mySourceRange = mySourceRange.CurrentRegion

where mySourceRange is already a defined range. There is a region of data
that's bounded by blank cells, but it only seems to find the first row of
data and I can't seem to figure out why.

Can someone assist?

Thanks,
Barb Reinhardt