Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete in different worksheets and workbooks
Hi Experts,
I am trying to repeat the procedure below (delete "Back To Contents" in 45 sheets and 11 workbooks), but I can not find the right code. I am doing with For next, but is deleting that only in the Active worksheet. Thanks Sub deleteBackToContents() n = Cells(Rows.Count, "A").End(xlUp).Row For i = n To 1 Step -1 With Cells(i, "A") If .Value = "Back To Contents" Then .EntireRow.Delete End If End With Next End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy/ move selected data from workbooks to seperate worksheets or workbooks | Excel Worksheet Functions | |||
How to delete duplicates between workbooks? | Excel Worksheet Functions | |||
How to delete duplicates between workbooks? | Excel Worksheet Functions | |||
Simultaneous rst.AddNew and rst.Delete from 2 Workbooks | Excel Programming | |||
Delete columns simultaneously in several different workbooks | Excel Discussion (Misc queries) |