CurrentRegion issue (attempt 2)
Barb, This worked for me.
Sub currgn()
Set myRng = Range("C9:C11")
myRng.CurrentRegion.Interior.ColorIndex = 3
MsgBox "Take a look"
myRng.CurrentRegion.Interior.ColorIndex = xlNone
End Sub
So it has nothing to do with having a previously defined range, apparently.
Must be some other quirk.
"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
|