View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TB TB is offline
external usenet poster
 
Posts: 26
Default Visual Basic code to find next available (blank) row in a spreadsh

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!