jbrown20bei
New Member
- Joined
- Aug 10, 2002
- Messages
- 17
I have a macro that opens another workbook or CSV file and creates a chart in that workbook.
the problem that I am having is that if the active tab in the opened workbook is a chart, it has no data to create a chart.
I need to determine if the active tab is a chart or a worksheet. Or I guess more accurately, I need to change the active tab to the worksheet and not a chart in the other workbook.
there is always only one tab that has data, but sometimes there are a few charts already created in that workbook.
I hope I'm being as clear as I can.
Thanks for your help, this community has been amazing over the years.
Jeff
the problem that I am having is that if the active tab in the opened workbook is a chart, it has no data to create a chart.
I need to determine if the active tab is a chart or a worksheet. Or I guess more accurately, I need to change the active tab to the worksheet and not a chart in the other workbook.
there is always only one tab that has data, but sometimes there are a few charts already created in that workbook.
I hope I'm being as clear as I can.
Thanks for your help, this community has been amazing over the years.
Jeff