Find Last Row or Empty Row in VBA

  • Thread starter Thread starter Kahuna
  • Start date Start date
K

Kahuna

Hi Folks

I have a sheet that I generate and save using automation from Access, and it
works OK. Problem is I cant add to the previously made sheet. I need to be
able to find the last row with data in the sheet (for a specific column) or
the first empty row.

Any suggestion on the VBA method that is used to do this?

Cheers (TIA)
 
Hi Kahuna,

Sub GotoBottomOfCurrentColumn()
'Tom Ogilvy 2000-06-26
Cells(Rows.Count, ActiveCell.Column).End(xlUp).Select
End Sub

since you want the next row
Cells(Rows.Count,ActiveCell.Column).End(xlUp).offset(1,0).Select
 
Spot on David - thanks for the quick response. Exactly what I needed.
 
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

Paste in column B using Last row of either column B, C or D. 10
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Determine the Empty row and/or column 1
find last updated row 2
Breaking One Row into Multiple Rows using VBA Macro? 2
Find Last Used Row 7
Count latest number of continous not-empty cells in a row. 11
find last row, copy until end 2

Back
Top