Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro: "Reference not valid"
I have two macros that I cannot use, edit, or delete.
Excel ver. 7 for Windows 95 : Tools - Macro dialog box One macro recently created, of the 3 in that box, works fine. How can I delete the bad ones? I suspect them of causing trouble. Thanks for any suggestions. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro: "Reference not valid"
On Mon, 19 Oct 2009 23:32:08 -0700, Mason C
wrote: I have two macros that I cannot use, edit, or delete. Excel ver. 7 for Windows 95 : Tools - Macro dialog box One macro recently created, of the 3 in that box, works fine. How can I delete the bad ones? I suspect them of causing trouble. Thanks for any suggestions. I solved my "reference not valid" problems by copying all seven sheets (using upper left button to highlight the entire sheet ) from the troubled workbook to a new workbook. The lost macros did not copy. It took a little work to erase the old workbook filename from the chart data series references. And recreate the macro I *did* want. All's clear now, thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table "Data source reference is not valid" error cause? | Excel Discussion (Misc queries) | |||
"Reference is not Valid" | Excel Discussion (Misc queries) | |||
=IF(VLOOKUP(C11,Group,2,FALSE)=D11,"True","Not Valid") and =IF(D1 | Excel Worksheet Functions | |||
"Reference not valid" error when I try to edit the macro in excel | Excel Discussion (Misc queries) | |||
Pivot Table - Error "Reference Is Not Valid" | Excel Discussion (Misc queries) |