Excel Sheet

  • Thread starter Thread starter Christina
  • Start date Start date
C

Christina

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
 
Sub DeleteRows()
Application.DisplayAlerts = False
Range(ActiveCell.Offset(1, 0), "A65536").EntireRow.Delete
Application.DisplayAlerts = True
End Sub
 
Thanks very much for your help. Is it possible to turn off promts in Excel,
eg when copying from one sheet to next and closing....do you want to close
etc?

Thanks
 
I tested it and it works, except it still prompts me to save etc. ANy other
ideas?


Thanks
 
Back
Top