This may be basic VB code but I need to write a code that will find the next
available blank row in a spreadsheet. Once I find it, I need additional code
to reference this particular row but not by row #. I will be locating the
next available blank row, adding data to this row and then graphing it. I
will need to know how to reference the newly identified row each month so the
code cannot be fixed (e.g., if I identify row 20 this month, it will not be
available next month because I will be appending the same file each month).
Any help would be greatly appreciated!

If column A can be used to make the determination

Dim rng as Range
set rng = Cells(rows.count,1).End(xlup).Offset(1,0)

--
Regards,
Tom Ogilvy

"TB" wrote in message
...
This may be basic VB code but I need to write a code that will find the
next
available blank row in a spreadsheet. Once I find it, I need additional
code
to reference this particular row but not by row #. I will be locating the
next available blank row, adding data to this row and then graphing it. I
will need to know how to reference the newly identified row each month so
the
code cannot be fixed (e.g., if I identify row 20 this month, it will not
be
available next month because I will be appending the same file each
month).
Any help would be greatly appreciated!

Thanks, Tom. That got me started in the right direction and I was able to
complete the code.

"Tom Ogilvy" wrote:

If column A can be used to make the determination

Dim rng as Range
set rng = Cells(rows.count,1).End(xlup).Offset(1,0)

--
Regards,
Tom Ogilvy

"TB" wrote in message
...
This may be basic VB code but I need to write a code that will find the
next
available blank row in a spreadsheet. Once I find it, I need additional
code
to reference this particular row but not by row #. I will be locating the
next available blank row, adding data to this row and then graphing it. I
will need to know how to reference the newly identified row each month so
the
code cannot be fixed (e.g., if I identify row 20 this month, it will not
be
available next month because I will be appending the same file each
month).
Any help would be greatly appreciated!