Please help with Range.Resize

  • Thread starter Thread starter Alexey
  • Start date Start date
A

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Iterative consolidation macro can't complete - memory overload? 5
Problem with progamatically defined named ranges 3
Getting at the range or cells 3
Copy to a mid column range Row 10 - Row 20 4
ModifyAppliesToRange question 0
Returning a named range source reference 3
How to get named range value? 5
Going through Named Ranges in only specific Sheets in my WorkBook 2

Back
Top