Spaces in sheet names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 said:
I wanted to ask the proper way to enter a String into Range() that
Click to expand...
contains a space (or many spaces) in it. For example (the excerpt from my
macro which triggers
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

select case syntax to other sheets 5
Userform textbox string to header causes unwanted double spacing 4
Named Ranges in various sheets 1
Post my named ranges in column A 10
Retrive a value from another worksheet in the same workbook 1
Excel sheet names with spaces 10
Adding spaces between ranges with save as macro 3
How to hide password? 1

Back
Top