Hi dok112

Try this with in A1 the value G33

Dim Num As Long
Num = Mid(Range("A1").Value, 2, 1024)
Range("A" & Num & ":C" & Num & ", F" & Num).Interior.ColorIndex = 3


--
Regards Ron de Bruin
http://www.rondebruin.nl


"dok112" wrote in message
...

No, it's actually a reference back to another worksheet cell.

Basically, I have a macro that is looking for a particular entry on a
sheet, it is then taking that cell and entering the actual cell
reference "G33" for example in this particular cell. Later a different
macro is going to use the "33" portion to color code certain cells that
end in "33", but not the "G33" cell. ie. Range("A33:C33, F33") will be
colored a specific color...


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=380380