Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete sheet that is referenced.
There are some people that work on the same excel. So everyone works on its sheet and I have to merge it. I'd like to delete old sheet from Excel and then copy new one. The problem is that there are sheets that have references on the first one. So after deletion they receive #REF instead of SheetName! in its formulas and never returned back even after I put sheet with the same name on it's place.
appl.EnableEvents = false; doesn't help. I understand that I can copy values of all cells but it'll take a lot of time. Is there any way to do it ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete sheet that is referenced.
I did at last
oldSheet.UsedRange.Clear(); newSheet.UsedRange.Copy(oldSheet.UsedRange); and it works very fast Is it the best way ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with referenced sheet (sorry for dups) | Excel Worksheet Functions | |||
Can a sheet be referenced by a value in a cell? | Excel Worksheet Functions | |||
Creating a master sheet referenced to multiple worksheets | Excel Discussion (Misc queries) | |||
Lookup funtion referenced from another sheet. | Excel Worksheet Functions | |||
Automate a date referenced in a formula pointing to another sheet | Excel Worksheet Functions |