Thread: Finding the next empty cell.
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
TJ Walls TJ Walls is offline
external usenet poster
  
Posts: 19
Default Finding the next empty cell.

Try:

ActiveSheet.UsedRange.Rows.Count + 1

On Tue, 18 May 2004 16:05:00 -0500, wrote:

Hi all,

A successful night so far as my first question was answered within
seconds!

I want to populate the next available empty cell in a column with the
results of a VB script that returns a string.

Can anyone tell me how to locate the next empty cell?

Thanks!


---
Message posted from http://www.ExcelForum.com/

Reply With QuoteReply With Quote