Select range between 2 different 'lastrows'

Hello,

I have been learning about vba a bit recently, and now I am trying to select a range between 'lastrow' and 'lastrow2' so I can enter a formula in that selected range.
Say Range("A1:A100") has values and Range("M1:M80") has values. I would like to enter a formula in Range("AA81:AA" & Lastrow)

Since selecting the range to the last row is done by using " Range("AA1:AA" & Lastrow). ", I tried replicating that Lastrow part in the first section of the range defining as well.
I tried using the following pieces of code, but it's giving me errors with the ':' part.

Please Login or Register  to view this content.

How can I write the last line so it selects the range between these two lastrows? I'm clueless at this point.

Thanks in advance!

Hello,

as the correct syntax is Range("AA" & Lastrow2 + 1 & ":AA" & Lastrow).Formula = …

Hi Marc,

That works perfectly, thank you very much!