CurrentRegion issue (attempt 2)
 

I discovered that my problem was a "user error" (mine).
Thanks to all,
Barb Reinhardt


"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