Use defined names in VBA?

[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!

 

[Frank Kabel]

Hi
try something like
dim rng as range
set rng=range("your_defined_name")
msgbox rng.address