Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
currentregion | Excel Discussion (Misc queries) | |||
CurrentRegion less one Row | Excel Programming | |||
CurrentRegion | Excel Programming | |||
CurrentRegion Selecting | Excel Programming | |||
CurrentRegion.copy maybe? | Excel Programming |