My data spreadsheet has several named ranges, with meaningful names. I'd like
to refer to them in VBA, but all attempts so far lead me to absolute
addresses like $R1$C1, or sheet1!R23C45. If a user cselects a named range how
can I read the name of the range (that might be a sinlge cell) and how can I
write to another named range (that will have many cells)?
Many thanks whoever is out there.