Finding next available row in column A

milobisconer

New Member
Joined
Jan 2, 2016
Messages
4
I use this macro to get to the the next available row in column A. Unfortunately it stops at the last used row. I need it to drop down one more row,
It's been a long time for me coming on this site so I have forgotten how to paste the macro correctly.

Sub FindNextRow()


'
' SeekNextRow Macro
' Go to next row
'
' Keyboard Shortcut: Ctrl+r
'
Range("A1048576").Select
Selection.End(xlUp).Select


End Sub
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

kweaver

Well-known Member
Joined
May 8, 2018
Messages
1,257
Office Version
  1. 365
  2. 2010
What about this?

Code:
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
 

mohadin

Active Member
Joined
Mar 22, 2015
Messages
490
Office Version
  1. 2013
Platform
  1. Windows
Code:
Cells(1, 1)(Rows.Count).End(xlUp)(2).Select
 

Watch MrExcel Video

Forum statistics

Threads
1,108,979
Messages
5,526,023
Members
409,675
Latest member
audeser

This Week's Hot Topics

Top