Help ASAP myRange
 

Here's my code

Range("A10").Select
ActiveCell.Offset(NStreets + 3, 19).Select

'SHADING HEADING RED

Set Myrange = Range("*ActiveCell.location*:"
Range("*ActiveCell.location*").Offset(0, 5).Address)
With Selection.Interior
.ColorIndex = 9
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With

I need to get to row X but X is based on "A10" + NStreets (unkown rows
+ 3. Where I've set the text as bold I need place what X is based o
because I don't have a starting cell. Instead of a starting cell
need to input A10 + NStreets + 3.

Help...

--
VB
-----------------------------------------------------------------------
VBA's Profile: http://www.excelforum.com/member.php...fo&userid=1649
View this thread: http://www.excelforum.com/showthread.php?threadid=27878