Dynamic Range Select Help

[alexduy]

Hi,

Can someone help me fix this formula Range("________________") to select a dynamic range. I would like to change it to something like this: Range("R1C1:R&FinalRowC26"). Thank you very much!

[CAntosh]

At a glance, without R1C1 it'd just be Range("A1:Z" & FinalRow)

With R1C1 I think it'd be Range("R1C1:R" & FinalRow & "C26"), though I admittedly don't use R1C1 often