hi,
after formatting,
I have some rows that contain "page xx of xx" and I want those lines deleted. i tried the following code , but to no avail:
Dim count
For count = Range("A" & Rows.count).End(xlUp).Row To 1 Step -1
If Range("A" & count) = "page*" Then Rows(count).Delete
Next
after formatting,
I have some rows that contain "page xx of xx" and I want those lines deleted. i tried the following code , but to no avail:
Dim count
For count = Range("A" & Rows.count).End(xlUp).Row To 1 Step -1
If Range("A" & count) = "page*" Then Rows(count).Delete
Next