How do I select a cell 5 cells from the active cell?

  • Thread starter Thread starter JasonK
  • Start date Start date
J

JasonK

seems simple enough, but i can't figure it out.

i am at a particular random location, and I need to select the cell 5
rows over.

TIA

JasonK
 
One way:

Public Sub SelectCell5RowsFromActiveCell()
With ActiveCell
If .Row <= Rows.Count - 5 Then _
.Offset(5, 0).Select
End With
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying zeros in cells 2
(Advanced Excel) Figuring out a formula of continuous progressiontrying to create 19 Formulas into O 5
loop until empty row and column problem (format cells until the lastrow and column in a report) 2
Populate cells based on row selection 1
summing cells in different sheets 3
macro to select a range from a set cell to a specified cell 6
making cells uncopyable 1
Retrieving data from a cell in the last row containing data in the worksheet 1

Back
Top