changing the address of sheet range

[Chrissirhc]

Hello,

How do I change the size of a range in a sheet?

the address property is read only

and when I do

range("data") = range("data").resize (10, 0)

I get an error.

Any ideas?

Thanks,

Chris

 

[GlennUK]

You mean change the range of a defined name maybe?

Names("data").RefersTo = Range("data").Resize(10, 3)

although your resize is trying to make a range of width zero columns ( not recommended ).


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.