Use defined names in VBA?

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

Frank Kabel

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