i'm trying to return the address of a named range.
ie: if i have a named range called "names" on worksheet "main"

C

4 Adam
5 Ben
6 Michael

I'de like to return "C4:C6"

i can do this on the sheet ADDRESS(ROW(names),COLUMN(names)) but VBA doesn't recognise these commands.