+ Reply to Thread
Results 1 to 1 of 1

formula/macro to return last non empty cell in a specified row

  1. #1
    Forum Contributor
    Join Date
    02-09-2004
    Posts
    154

    formula/macro to return last non empty cell in a specified row

    Basically I have a macro which copies some data from one sheet over to a sort of historical sheet, and puts the current date along row 3.

    What I need is to prevent it overwriting the data the next time the macro is run, i.e. I want it to go to the next column over and add the new stuff in there each time the thing is run.

    So I need something that will give me the last non empty cell on row 3 so I can then tell the macro to use column x when it pastes the stuff in. this must be very common but I havent managed to work out how to do it yet.

    I also need to know how to make the macro use this, i.e. I currently have Range("C5").Select but what I need it to say is Range("<first empty column on row 3>5").select i.e. I need to keep the current row numbers in there (in this case 5), but the column has to be variable based somehow, I just dont know how to format it.

    Thanks
    Last edited by neowok; 01-10-2005 at 10:40 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1