I also will want to use xlLastCell to pick a range, as in,
Range("B3:xlLastCell"). How can I do that?

I'm basically creating a table for my data, along with background
shading. The data in the table will change occasionally, so the
borders and shading will need to be reapplied and resized as
necessary.

Am I doing it wrong?


--
Coolboy55
------------------------------------------------------------------------
Coolboy55's Profile: http://www.excelforum.com/member.php...o&userid=26508
View this thread: http://www.excelforum.com/showthread...hreadid=397766