View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Merlynsdad Merlynsdad is offline
external usenet poster
 
Posts: 37
Default Excel sheet names with spaces

OK, but how would you refer to this sheet in the ListFillBox property of an
Excel list box?

"Jacob Skaria" wrote:

Dim ws as Worksheet
Set ws = Sheets("DCI data")

Msgbox ws.Range("A1")


If this post helps click Yes
---------------
Jacob Skaria


"Merlynsdad" wrote:

I have a sheet name in Excel that is "DCIdata". The file owner has now
changed it to "DCI Data". I have several references to the sheet in VBA as
DCIdata!. How do I refer to this sheet now that it has a space in it?