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?
|