Visual Basic code to find next available (blank) row in a spreadsh

[TB]

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!

[Tom Ogilvy]

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" <TB@discussions.microsoft.com> wrote in message
news:7BA50427-0655-47E2-894F-B0AC375204E4@microsoft.com...
> 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!

[TB]

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" <TB@discussions.microsoft.com> wrote in message
> news:7BA50427-0655-47E2-894F-B0AC375204E4@microsoft.com...
> > 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!
>
>
>