Enter a Formula with Variable Data

[mpeplow]

I'm trying to use this

Please Login or Register  to view this content.

I want "488" to be "(FinalRow - 1)"

I've tried many way replace the "488" with my variable - 1, or a new variable that already had the '-1', I couldn't get anything to work.

Does anyone know how to do this?

[Leith Ross]

Hello Mpeplow,

This worked for me...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[mpeplow]

Thanks! Yeah, I just realized that it was a string.

I'm using

Please Login or Register  to view this content.

[VBA Noob]

Just to be different...and more long-winded

Please Login or Register  to view this content.

VBA Noob