Try wrapping the sheet name in single quotes:
cell_name = "'sheet name with spaces'!$A$1"


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Minilek" wrote in message
...
I wanted to ask the proper way to enter a String into Range() that
contains a space (or many spaces) in it. For example (the excerpt from my
macro which triggers
the error):

cell_name = "sheet name with spaces!$A$1"
foo = q & Range(cell_adr) & q & ","

(I've set q to be the double quotation character).

I suspect the error occurs because of the spaces
because if I change the sheet's name to say,
"sheetwithnospaces" then there's no problem.