PDA

View Full Version : activeworkbook.name space



impius
02-27-2009, 02:29 PM
Hello all,

I have the code below...

ActiveChart.SeriesCollection(1).XValues = "=" & ActiveWorkbook.Name & "!x"


This is part of some code to graph data from a named range. Everything works perfectly until the workbook has a space in the name. For example "Myworkbook" works but "My Workbook" does not.

Any way around this?

impius
02-27-2009, 02:32 PM
Nevermind...I got it...

ActiveChart.SeriesCollection(1).XValues = "=" & "'" & ActiveWorkbook.Name & "'" & "!x"