Please help with Range.Resize

[Alexey]

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

What is the right way to do this?

 

[Bob Phillips]

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

 

[Alexey]

Thanks

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


--
__________________________________
HTH

Bob