Select bottom right hand cell in range

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hi
Is there a way to select the bottom right hand cell in a named range?
I am using a dynamic range and would like to make the bootom right hand cell
the ActiveCell

=OFFSET(Solo!$C$5,0,0,COUNT(Solo!$C$5:$C$350),4)

So if the above selected C5:F12, how would I make select F12 and make it
active, bearing in mind that the range will vary depending on how may of the
cells in Column C are filled.

Any suggestions? Thanks. Jim
 
Jim,

Is this in VBA? If so, try this

range("Solo")(range("Solo").Rows.count,range("Solo").Columns.Count).select


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
=OFFSET(solo,ROWS(solo)-1,COLUMNS(solo)-1,1,1

----- Jim wrote: ----

H
Is there a way to select the bottom right hand cell in a named range
I am using a dynamic range and would like to make the bootom right hand cel
the ActiveCel

=OFFSET(Solo!$C$5,0,0,COUNT(Solo!$C$5:$C$350),4

So if the above selected C5:F12, how would I make select F12 and make i
active, bearing in mind that the range will vary depending on how may of th
cells in Column C are filled

Any suggestions? Thanks. Ji
 
one more VBA option:

Option Explicit
Sub testme()
Dim myRng As Range
Set myRng = Worksheets("solo").Range("test1")
With myRng
.parent.select
.Cells(.Cells.Count).Select
End With
End Sub

Where test1 was the name defined with your formula.
 
Back
Top