Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Objects Q
I have a piece of code below that deletes all objects within my sheet
"Current". But what I'm finding is that Cell C6 is being deleted and all cells in this column shift up one. Why would this happen? I have just run the macro below only, so there is no other influences, but can't understand why it is happening. If I run it a second time it deletes another row and again shifts up one cell. Any help appreciated Sub ClearMacroButtons() Sheets("Current").Select ActiveSheet.DrawingObjects.Select Selection.Delete Range("A1").Select End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Objects Q
Prolem solved I was missing "Cells.Select"
"John" wrote in message ... I have a piece of code below that deletes all objects within my sheet "Current". But what I'm finding is that Cell C6 is being deleted and all cells in this column shift up one. Why would this happen? I have just run the macro below only, so there is no other influences, but can't understand why it is happening. If I run it a second time it deletes another row and again shifts up one cell. Any help appreciated Sub ClearMacroButtons() Sheets("Current").Select ActiveSheet.DrawingObjects.Select Selection.Delete Range("A1").Select End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting Objects Q
Hi John
See http://www.rondebruin.nl/controlsobjectsworksheet.htm -- Regards Ron de Bruin http://www.rondebruin.nl "John" wrote in message ... I have a piece of code below that deletes all objects within my sheet "Current". But what I'm finding is that Cell C6 is being deleted and all cells in this column shift up one. Why would this happen? I have just run the macro below only, so there is no other influences, but can't understand why it is happening. If I run it a second time it deletes another row and again shifts up one cell. Any help appreciated Sub ClearMacroButtons() Sheets("Current").Select ActiveSheet.DrawingObjects.Select Selection.Delete Range("A1").Select End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting HTML form objects? | Excel Discussion (Misc queries) | |||
Deleting Objects Copied from Web Page | Excel Discussion (Misc queries) | |||
deleting objects | Excel Programming | |||
deleting objects using VBA | Excel Programming | |||
Deleting name-objects | Excel Programming |