L
Larry A
I would appreciate any thoughts on how to set up a macro to build an
inventory list of all range names in a spreadsheet with associated sheet
names and cell ranges. What I have so far is:
sub BuildRangeNameList()
dim i as integer, s as string, n as name
for i = 1 to activeworkbook.name.count
set n = activeworkbook.name(i)
s = n.name
next i
end sub
How do I find the associate sheet name? And asociated cell range in
non-R1C1 format?
Thanks in advance. Larry.
inventory list of all range names in a spreadsheet with associated sheet
names and cell ranges. What I have so far is:
sub BuildRangeNameList()
dim i as integer, s as string, n as name
for i = 1 to activeworkbook.name.count
set n = activeworkbook.name(i)
s = n.name
next i
end sub
How do I find the associate sheet name? And asociated cell range in
non-R1C1 format?
Thanks in advance. Larry.