Deleting multiple ranges at once
Deleting multiple ranges at once
(OP)
I would like to delete multiple ranges from multiple spreadsheets at once.
Example:
A workgroup has three Spreadsheets
Sheet 1:
delete the range from c4 to c53 and f4 to f53.
Sheet 2:
Delete the range from c62 to d84
Sheet 3:
Delete the range from a11 to d3 and f2 to k70
I would like to delete all of this ranges by click a button in the spreadsheet. Please advise how I may accomplish this.
Thank you very much!
Example:
A workgroup has three Spreadsheets
Sheet 1:
delete the range from c4 to c53 and f4 to f53.
Sheet 2:
Delete the range from c62 to d84
Sheet 3:
Delete the range from a11 to d3 and f2 to k70
I would like to delete all of this ranges by click a button in the spreadsheet. Please advise how I may accomplish this.
Thank you very much!





RE: Deleting multiple ranges at once
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Deleting multiple ranges at once
Private Sub CommandButton1_Click()
Sheet1.Range("C4:C53,F4:F53").ClearContents
Sheet2.Range("C62:D84").ClearContents
Sheet3.Range("A11:D3,F2:K70").ClearContents
End Sub
RE: Deleting multiple ranges at once
Thank you johnwm for your comments.