HI,
I would like to know to selected multiple ranges and clear the
contents
presently my code is like this:
Range("C2:L2").Select
Selection.ClearContents
Range("N2").Select
Selection.ClearContents
ActiveWindow.SmallScroll ToRight:=6
Range("O2:R2").Select
Selection.ClearContents
Range("T2:W2").Select
Selection.ClearContents
I wanted to writed in one line like:
Range("C2:L2","N2","O2:R2","T2:W2").Select
Selection.ClearContents
Any possibility.
thanks in advance
regards
nowfal
--
nowfal
------------------------------------------------------------------------
nowfal's Profile:
http://www.excelforum.com/member.php...o&userid=10003
View this thread:
http://www.excelforum.com/showthread...hreadid=392092