VBA to go to bottom row (with data) in a sheet

[aaronglover]

Hi all,
I am trying to create an excel macro that will go to the bottom row of data in a given sheet, then go down 1 more row, then paste some new data. What I want to do is create a continuous table of data that just that I can append new data at the end automatically with the use of a macro.

Any thoughts?
Thanks

 

[VoG]

Dim NextRow As Long
NextRow = Cells(Rows.Count, 1).End(xlUp).Row + 1

will give you the number of the first empty row in column A.

 

[Norie]

Where's the new data coming from?

You can determine the next blank row in various ways.

For example:

NextRow = Range("A" & Rows.Count).End(xlUp).Row+1

 

[daniels012]

do you need it for a specific column (like Column A) or any column that has data in it?

Michael

 

[aaronglover]

The first post worked perfectly. You guys rock as usual.