I am trying to create a new range, the size of a different range.

[magnus101]

I am trying to create a new range, the size of a different range.

So, my old range is test1
I can get the number of columns and rows
range("test1").Rows.count
range("test1").Columns.count

However, now I want to create a new range, that size, starting at G5
How can you get the ending column? G + Columns.count isn't going to work?

Is there an easy way of doing this?

thanks

[Richard Buttrey]

Hi,

Perhaps

Range("G5").Resize(Range("test1").rows.count,Range("test1").columns.count).Name = "MyNewRangeName"