I am having a strange error when I try to delete my old charts in my excel workbook. Below is the code I am using to try to get the Workbooks property to work:
Sub Selecting_Charts() Workbooks("Op 70.xls").Activate Sheets("Charts").Select Workbooks("Op 70.xls").Charts.Select 'Error here! End Sub
I keep getting the error "Method 'Select' of object 'Sheets' failed" when trying to run the code. I don't know anything more to try to get my program to select that workbook. I also tried the 'ThisWorkbook' property but that produced the same error.
Please help me on this issue. I greatly appreciate it.