I'm trying to get VBA to select the contents of a cell and stick it int
a variable for me. I need it formatted and so I'm trying the followin
but it doesn't work. Var is returned as "- 1"

Var = Format(Range(Row & Col).Select, "### #### ##")

tried this but it then sets Var to empty
Var = Format(Cells(Row, Col).Value, "### #### ##")


Can anybody help me

--
Message posted from http://www.ExcelForum.com