Range("AF2:BI2").ClearContents

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lizz45ie" wrote in
message ...

Hello,
I would like to clear columns on my Excel worksheet using VBA. I tried
some simple code and it only deleted some of the columns. Here is what
I tried.

Range("AF2:BI2").Select
Selection.EntireColumn.Delete


Thanks for any help you can provide.


--
Lizz45ie
------------------------------------------------------------------------
Lizz45ie's Profile:
http://www.excelforum.com/member.php...o&userid=23410
View this thread: http://www.excelforum.com/showthread...hreadid=481924