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