Add name problem

  • Thread starter Thread starter Luc
  • Start date Start date
L

Luc

I want to assign the name "Grafiek" to the selected cells (not the
CurrentRegion like in the code below)

What code should i use ?


ActiveWorkbook.Names.Add Name:="Grafiek", RefersToR1C1:= _
ActiveCell.CurrentRegion


Thanxxx,

Luc
 

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

Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
Exporting graphs causes unwanted resizement! 1
Resize Range for Column 3
Selecting & copying a named range through a listbox 1
Why does this mouse menu call a sub from another workbook? 2
naming ranges in Excel2007 using VBA 2
How to select the bottom right cel in a 'CurrentRegion.selecion' 3
Chart2JPG and export to webpage directory 3

Back
Top