Thread: Please help with Range.Resize
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alexey[_3_] Alexey[_3_] is offline
external usenet poster
  
Posts: 11
Default Please help with Range.Resize
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?
Reply With QuoteReply With Quote