View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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