Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry, thanks very much. Code was copied too high in macro dialog box.
Thanks again. "Luke M" wrote: Sub DeleteRows() Application.DisplayAlerts = False Range(ActiveCell.Offset(1, 0), "A65536").EntireRow.Delete Application.DisplayAlerts = True End Sub -- Best Regards, Luke M "Christina" wrote in message ... Good morning, Need help with: Code to delete all rows in Column A below active cell Turn off warnings in a macro, specifically I am copying a spreadsheet to a new one, and close original, don't want pop up box to ask if file needs to be saved etc. Thanks Cristina . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populate excel sheet based on values in a separate sheet | Excel Discussion (Misc queries) | |||
Split text file into Excel sheet and separate the final results intoa new sheet | Excel Worksheet Functions | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Excel worksheet - Can I make changes in one sheet affect contents of other sheet? | Excel Discussion (Misc queries) | |||
Updating excel sheet with selected data from another sheet in the same file | Excel Worksheet Functions |