Use NEXT empty cell in excel

Harrij · #1 (**permalink**) 10-12-04, 08:21

How do i get to automaticly have VB put the copied cell of a worksheet in the next available EMPTY cell in another workbook ??

n00bl0rd · #2 (**permalink**) 10-13-04, 05:47

in the next available row?

Code:

intNextCell = Sheet1.UsedRange.Rows.Count + 1

Sheet1.Cells(intNextCell, col) = value

Harrij · #3 (**permalink**) 10-14-04, 16:58

I want to send a fixed cell (-value) from one worksheet to another worksheet
on a different HD and place the value in one row. It needs to fill the next empty cell with new data everytime ( downwards ) !!

The application needs to start at 23:55 and close itself at 23:59.

Internet Services

Web Development

Digital Marketing

Consumer Tech