Thanks! This is exactly what I was looking for.


-----Original Message-----
Range(Cells(TopLeftRow,TopLeftColumn),Cells
(BottomRightRow,BottomRightColumn
)).Select



Note that you don't need to 'select' a range to use it..
With
Range(Cells(TopLeftRow,TopLeftColumn),Cells
(BottomRightRow,BottomRightColumn
))
.Clear
.Interior.Colorindex=3
End With

--
Patrick Molloy
Microsoft Excel MVP
----------------------------------
"Bob J." wrote in message
...
Does anybody know what the marco command(s) are for
selecting a range of cells in a column using a
variable?


.