M
MultiMatt
I have a report that generates into Excel and it leaves some crap in
the last few rows that no one needs. It results in a few extra pages
printing out (unless someone takes the time to manually remove those
rows).
I have a macro which does a lot of formatting to this particular
report, to dress it up before printing. I'd like to be able to add a
macro which would search for some specific data located in a cell near
the bottom, then delete THAT row and the next 20 or so rows.
The data to look for is: ASC database on SQL Server
It's located in column B, but depending on the report, the row
varies...
Any help would be greatly appreciated!
Matt
the last few rows that no one needs. It results in a few extra pages
printing out (unless someone takes the time to manually remove those
rows).
I have a macro which does a lot of formatting to this particular
report, to dress it up before printing. I'd like to be able to add a
macro which would search for some specific data located in a cell near
the bottom, then delete THAT row and the next 20 or so rows.
The data to look for is: ASC database on SQL Server
It's located in column B, but depending on the report, the row
varies...
Any help would be greatly appreciated!
Matt