|
Hi,
I have a macro running in one of our teams that opens each one of a series of files, created (populated) by different persons at different times during the day, but which all look alike in structure.
The problem I'm currently facing is this:
- I need a way of finding out the last filled row - so I can fill out certain formulas and define the range I have to copy into another file.
<=> There is a named table_area, so I cannot select the last cell at the bottom of the sheet and then jump up using xlUp
=> So what I do currently is, I go from line to line querying the length of the value using Len(ActiveCell.Value)
<=> This does sometimes cause malfunctions because some people have empty lines either at the very top of their list of entries or somewhere inbetween,
in each case my macro will make that the last row, thus missing out on some rows.
I have already spoken to the supervisor in that area, but nobody can rule out that this is going to happen in future and I cannot have him open and check every file before running my macro, else he might as well do all the work himself ...
=> Is there a way I can deal with that? I will experiment a bit myself, but I'll be happy for every proposition, too.
Thanks a lot!
Best regards,
Officer_Bierschnitt
|