try:
not sure if the syntax is correct, but since Finalrow is the last row used in the U column and you are subracting it from the activecell which is one more than the final row, it should give you the correct begining row
given that Finalrow is derived correctly, and for each sheet that the formula will go in
also, since you are starting from a static cell that is the same over sheets then you don't need to use R1C1. R1C1 is used if there are multiple columns and rows involved and the formula itself is in multiple places
should work too
Bookmarks