Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2004
    Posts
    3

    Cool Unanswered: Use NEXT empty cell in excel

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

  2. #2
    Join Date
    Oct 2004
    Posts
    8
    in the next available row?

    Code:
    intNextCell = Sheet1.UsedRange.Rows.Count + 1
    
    Sheet1.Cells(intNextCell, col) = value
    Last edited by n00bl0rd; 10-13-04 at 06:49.

  3. #3
    Join Date
    Oct 2004
    Posts
    3

    Exclamation next empty cell in same row !

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •