Macro selecting cells

[howard]

I would like to macro that will select the first cell column M staring from row 5 up until the last value in Col M

Your assistance in this regard will be most appreciated

 

[AlphaFrog]

Sub M_Select()
    Range("M5", Range("M" & Rows.Count).End(xlUp)).Select
End Sub

 

[brettdj]

If you wanted to present the range to the user for modifying or for confirm/stop then you could use this variant

Cheers

Dave

Sub RangeFlag()
    Dim rng1 As Range
    On Error Resume Next
    Set rng1 = Application.InputBox("Please confirm user selected range", , Range([m5], Cells(Rows.Count, "M").End(xlUp)).Address, , , , , 8)
    On Error GoTo 0
    If Not rng1 Is Nothing Then
        'do something
    Else
        MsgBox "user cancelled", vbCritical
    End If
End Sub

 

[howard]

Thanks for the help, much appreciated

 

[howard]

Hi Dave

Thanks for the input, much appreciated.

Regards

Howard