Not clear what you're actually trying to do here. You seem to be trying to
use LastRow before you create it, but I can't tell because you have omitted
the important lines of code.

Please provide the full code  involved.