Variable Range set?

[Chas17]

In part of my vb code I have:

Set rngeSend = Range("O1:O15")

The range O1:O15 may change and say be O1:O25.
Is there a way I can Set rngeSend to a variable? Or how do I set the range each time based on a column count?

Thanks, Chas

 

[Juan Pablo González]

How do you calculate the 15 or the 25 ?

Something like this may guide you:

Dim lastRow as Long, rng As Range

lastRow = 25    'Your calc here
Set rng = Range("O1:O" & lastRow)

 

[Chas17]

lastRow = Range("lastrow") 'Your calc here
Set rngeSend = Worksheets("Unit 1").Range("O1:P" & lastRow)

Range named last row contains =COUNTA(N1:N65)

Thank you! Thank you! works perfect

Thanks, Chas