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
How about:
Range("C2:L2,N2,O2:R2,T2:W2").ClearContents
No need to select first.
nowfal wrote:
>
> 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
--
Dave Peterson
hi
As you wished.
Range("C2,C2:L2,N2,O2:R2,T2:W2").Select
But you do know that N2,O2:R2 is the same as N2:R2.
Regards
FSt1
"nowfal" wrote:
>
> 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
>
>
Hi Mr.Dave Peterson,
Done, thank u very much. It saves lot of time while running the macro.
with regards
nowfal
Did you see FSt1's note:
But you do know that N2,O2:R2 is the same as N2:R2.
Sometimes, cleaning this kind of thing up when you notice it means you won't be
wondering why you did it that way before.
nowfal wrote:
>
> Hi Mr.Dave Peterson,
> Done, thank u very much. It saves lot
> of time while running the macro.
> 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
--
Dave Peterson
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
Fstl's point was that the cell N2 is inside the range O2:R2, so:
This formula
Range("C2:H2,J2:L2,N2,O2:R2,T2:W2,Y2:AB2,AD2:AG2").ClearContents
is equivalent to:
Range("C2:H2,J2:L2,O2:R2,T2:W2,Y2:AB2,AD2:AG2").ClearContents
You wouldn't have to specify N2, since it's in the middle of O2:R2.
nowfal wrote:
>
> 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
--
Dave Peterson
Hi Dave,
First of all, i dont like to argue with my teacher. So it is not an argument, just to reply thats all.
AB CDEFGH I JKL M N OPQR STUVWXYZ.
I think u got it. N is not in the middle of OPQR. And I seperated the N with a coma before and after. I think this confusion started by Mr.Fstl. After all I dont want to eat your valuable time. Thanks for the reply.
with regards
nowfal
You are absolutely correct. (Stupid alphabet changes for me sometimes.)
Bun N2:R2 would include O2.
Range("C2:H2,J2:L2,N2:R2,T2:W2,Y2:AB2,AD2:AG2").ClearContents
(I just screwed up FStl's note. It was my error, not his.)
nowfal wrote:
>
> Hi Dave,
> First of all, i dont like to argue with my teacher. So it
> is not an argument, just to reply thats all.
> AB CDEFGH I JKL M N OPQR STUVWXYZ.
>
> I think u got it. N is not in the middle of OPQR. And I seperated the
> N with a coma before and after. I think this confusion started by
> Mr.Fstl. After all I dont want to eat your valuable time. Thanks for
> the reply.
> 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
--
Dave Peterson
More problems with the alfabet/fingers!
Bun N2:R2 would include O2.
should be:
But N2:R2 would include O2.
Dave Peterson wrote:
>
> You are absolutely correct. (Stupid alphabet changes for me sometimes.)
>
> Bun N2:R2 would include O2.
>
> Range("C2:H2,J2:L2,N2:R2,T2:W2,Y2:AB2,AD2:AG2").ClearContents
>
> (I just screwed up FStl's note. It was my error, not his.)
>
> nowfal wrote:
> >
> > Hi Dave,
> > First of all, i dont like to argue with my teacher. So it
> > is not an argument, just to reply thats all.
> > AB CDEFGH I JKL M N OPQR STUVWXYZ.
> >
> > I think u got it. N is not in the middle of OPQR. And I seperated the
> > N with a coma before and after. I think this confusion started by
> > Mr.Fstl. After all I dont want to eat your valuable time. Thanks for
> > the reply.
> > 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
>
> --
>
> Dave Peterson
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks