Deleting data in 7 different sheets before I update workbook. [Closed]

Question

Deleting data in 7 different sheets before I update workbook. [Closed]

Report

haharrison2

Posts: 10
Registration date: Friday January 6, 2017
Status: Member
Last seen: February 7, 2017

- Jan 30, 2017 at 09:03 PM
haharrison2

Posts: 10
Registration date: Friday January 6, 2017
Status: Member
Last seen: February 7, 2017

- Feb 7, 2017 at 02:06 PM

Sub Delete()
'
' Macro4 Macro
' Delete contents in attorney tabs
'
' Keyboard Shortcut: Option+Cmd+Shift+D
'
Dim lRow As Long
Dim i As Long

lRow = Range("A" & Rows.Count).End(xlUp).Row

Range("AAV, DMC, MWW, OCT, RSB, TCR, WJC, UNKN").Select
Range("A3").Select
ActiveWindow.ScrollDown = UBound() 'THIS ROW GIVES ME A SYNTAX ERROR.
Range("A3:UBound").Select 'DO YOU KNOW A FIX FOR THIS.
Selection.ClearContents 'I have a Mac

End Sub

Deleting data in 7 different sheets before I update workbook.
How to delete data from cd in windows 7 - How-To - Windows 7
How to copy data from one excel sheet to another - How-To - Excel
Copying data from one Excel sheet to another. ✓ - Forum - Excel
How to map data in two excel sheets - How-To - Excel
How to delete data from write protected pen drive - How-To - USB

1 reply

Ask a question

haharrison2 · Answer 1 · 2017-02-07T14:06:43-0500

Answer 1 / 1

haharrison2

Posts: 10
Registration date: Friday January 6, 2017
Status: Member
Last seen: February 7, 2017

Feb 7, 2017 at 02:06 PM

I have resolved this problem and am no longer need of help. Thank you.

Deleting data in 7 different sheets before I update workbook. [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!