View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve C Steve C is offline
external usenet poster
 
Posts: 119
Default Find Empty Cell in Row

I have seven columns, under which I wish to have eight rows of information.
Starting with the first empty cell, I will be pasting information from other
areas of my spreadsheet. I need my code (after an item is copied to the
clipboard) to search each row starting from the top and locate the first
available empty cell, into which the item is then pasted. The code must
search the rows from left to right, and if full, move to the next row and
continue the search. Can someone help? Thanks!

Steve