ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro (https://www.excelbanter.com/excel-programming/318560-macro.html)

D

Macro
 
Hi:

I would like to have a macro that deletes the row headings that are always
the same; I could record that. but, I also want to delete the rows at the
end of the file that are always not in the same position. Ho do I check when
the file is ending and delete the next rows?

First col. is numeric; but the problem is, that sometimes the first invalid
row that I want to be deleted starts with a number?!

Thanks in advance,

Dan

JulieD

Macro
 
Hi D

how do you identify the rows at the end to delete?

Cheers
JulieD

"D" wrote in message
...
Hi:

I would like to have a macro that deletes the row headings that are always
the same; I could record that. but, I also want to delete the rows at the
end of the file that are always not in the same position. Ho do I check
when
the file is ending and delete the next rows?

First col. is numeric; but the problem is, that sometimes the first
invalid
row that I want to be deleted starts with a number?!

Thanks in advance,

Dan





All times are GMT +1. The time now is 03:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com