+ Reply to Thread
Results 1 to 3 of 3

Modify starting cell in code

  1. #1
    Forum Contributor
    Join Date
    02-26-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    248

    Modify starting cell in code

    Wondering if there is an easy way to modify this code so that the first time it is run (when there is no data) it pastes the data starting at A3 but afterwards pastes starting at the last row or first empty cell in col. A.

    Please Login or Register  to view this content.
    Attached Images Attached Images

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,481

    Re: Modify starting cell in code

    How about this?
    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    02-26-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    248

    Re: Modify starting cell in code

    BINGO! Thank you so much davesexcel. That did it!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA code to log the username that last modify the cell in excel
    By ecuaton in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-17-2016, 11:37 AM
  2. [SOLVED] Modify code to erase data when another cell is cleared
    By Nitefox in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 8
    Last Post: 12-15-2013, 11:06 PM
  3. Replies: 1
    Last Post: 03-29-2013, 02:42 AM
  4. Modify Code to Log Cell Input and Value
    By HP RodNuclear in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-12-2011, 10:13 AM
  5. [SOLVED] Modify Current VBA Cell Background Color Code
    By boldcode in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2011, 02:29 AM
  6. How do I modify my VBA cell splitter code?
    By stormracela in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-07-2010, 12:30 AM
  7. modify this code to delete a cell in all the given workbooks in a folder.
    By mrgillus in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-02-2009, 04:20 PM

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