Thread: multiple range
View Single Post
  #6   Report Post  
nowfal
 
Posts: n/a
Default


Hi Mr.Dave Peterson,
I saw his(FSt1) question, but it is
not inside that. N2 is separately cleaning , i wanna to avoid 5 cells
from clean ie. M2,S2,X2,AC2,AH2 b coz it contains formula that too the
macro unprotecting the sheet on the begining.

(Range("C2:H2,J2:L2,N2,O2:R2,T2:W2,Y2:AB2,AD2:AG2" ).ClearContents)

. As u said to be frank , 3 months before i was nothing (still i am a
KG student comparing guys like u) now atleast i can say i have done
some good work, which is using almost 50 people in different branches
of my company. So better portion of the credit goes to guys like u
Dave, Bob, etc etc . So keep it up helping others.
Thanks a lot
with 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