[SOLVE] set 2 cells as a range

[phoeberunner]

Hi,

I want to set a range with 2 cells which are not next to each other, here is my code,

Set rng = Range(Cells(10, 5).Address & "," & Cells(10, 8).Address)

It caused error, anyone can solve this?

Thanks,
Phoebe

 

[prajul89]

Re: set 2 cells as a range

It seem good to me. I don't think there is any problem!!!

 

[evnoort]

Re: set 2 cells as a range

Try loosing the adress part.

See http://support.microsoft.com/kb/291308

 

[phoeberunner]

Re: set 2 cells as a range

It seem good to me. I don't think there is any problem!!!

Somehow it works now! Sorry!

 

[prajul89]

Re: set 2 cells as a range

Try loosing the adress part.

See http://support.microsoft.com/kb/291308

I don't think that will do any difference!

 

[Trebor76]

Re: set 2 cells as a range

To set a range for E10:H10 try this...

Set Rng = Range(Cells(10, 5), Cells(10, 8))

...or for just the two cells E10 and H10 your original code is correct (note the ".Address" is needed in this case).

HTH

Robert