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!