Syntax To Add A Variable to a Range

[Genus Max]

Hi, im trying to add a variable to a range, something like this Set myRange = Range("A70:lRow"), but cant figure out the syntax.

Thanks.

Please Login or Register  to view this content.

[Pepe Le Mokko]

In the future please post in the correct forum (VBA in this case). I will move it there

[protonLeah]

Set myRange = Range("A70:" & lRow)

- or -

Please Login or Register  to view this content.