I need to resize a Range from a Name object, but always receive errors.
....
ThisWorkbook.Names("data").RefersToRange.Rows.Resi ze(10)

What is the right way to do this?

Range("data").Resize(10).Name = "data"


--
__________________________________
HTH

Bob

"Alexey" wrote in message
...
I need to resize a Range from a Name object, but always receive errors.
...
ThisWorkbook.Names("data").RefersToRange.Rows.Resi ze(10)

What is the right way to do this?

Thanks

"Bob Phillips" wrote:

Range("data").Resize(10).Name = "data"


--
__________________________________
HTH

Bob

"Alexey" wrote in message
...
I need to resize a Range from a Name object, but always receive errors.
...
ThisWorkbook.Names("data").RefersToRange.Rows.Resi ze(10)

What is the right way to do this?