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

Dim myRng as range
dim myCell as range

'somewhat the user defines myRng

set mycell = myrng.cells(1)



J@Y wrote:

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

--

Dave Peterson

Thanks. What about the last cell?

"Dave Peterson" wrote:

Dim myRng as range
dim myCell as range

'somewhat the user defines myRng

set mycell = myrng.cells(1)



J@Y wrote:

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

--

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




J@Y wrote:

Thanks. What about the last cell?

"Dave Peterson" wrote:

Dim myRng as range
dim myCell as range

'somewhat the user defines myRng

set mycell = myrng.cells(1)



J@Y wrote:

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

--

Dave Peterson


--

Dave Peterson