Use defined names in VBA?

  • Thread starter Thread starter JRocket02
  • Start date Start date
J

JRocket02

Hi all

Any way to have Excel generate links or dimension variables so that VBA can
use the defined names on the spreadsheet (menu: insert > name > define)? Or
is it best to just Dim all the same variable names in code to match the
defined names? Thanks!
 
Hi
try something like
dim rng as range
set rng=range("your_defined_name")
msgbox rng.address
 
Back
Top