Thread: multiple range
View Single Post
  #10   Report Post  
Dave Peterson
 
Posts: n/a
Default

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").Cl earContents

(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