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.