using a variable in a R1C1 formula

Please Login or Register  to view this content.

This formula works, but I’d like to change the R[1000] to R[iLastRow], but it doesn’t work.
Is there a way to include my iLastRow variable into the formula?

I’m counting the visible lines in a filtered list because I only want to print the listing if there is actual data.