Find the beginning Cell of a Range

[Guest]

I have a user input a range, how can I store the beginning cell of that range
in a variable?

 

[Dave Peterson]

Dim myRng as range
dim myCell as range

'somewhat the user defines myRng

set mycell = myrng.cells(1)

 

[Guest]

Thanks. What about the last cell?

Dim myRng as range
dim myCell as range

'somewhat the user defines myRng

set mycell = myrng.cells(1)

 

[Dave Peterson]

In a one area range:

Dim myRng as range
dim myCell as range

'somewhat the user defines myRng

with myrng
set mycell = .cells(.cells.count)
end with

with a multi-area range

with myrng
with .areas(.areas.count)
set mycell = .cells(.cells.count)
end with
end with