Highlighting large blocks of data.

  • Thread starter Thread starter Roger R
  • Start date Start date
R

Roger R

I'm looking for the VBA statment that created the action
that happens when you press "end" then the down arrow.
I'm trying to highlight a block of data with the key
strokes: (holding down) "shift" + "right arrow" from
column A to E, then "end" and "down arrow". When I record
this action the marco stated the exact area highlighted,
but I want it to be more of a variable, so I can us it on
different blocks of data.

Thanks
Roger
 
One way:

Public Sub SelectDown
Range(ActiveCell,ActiveCell.End(xlDown)).Select
End Sub
 
hi roger,

you could adapt something of the following...


Code
-------------------
Sub selDown()

'This will start from range which is currently selected
Range(Selection, Selection.End(xlDown)).Select

End Su
 
Back
Top