+ Reply to Thread
Results 1 to 3 of 3

Can't paste to next empty column

  1. #1
    Registered User
    Join Date
    01-30-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    12

    Can't paste to next empty column

    Hello,

    I have a spreadsheet that has been working for a year with the following:


    Please Login or Register  to view this content.
    It should at this point be pasting to JB1 and JB2 but it keeps pasting to D1 and D2. D1 and D2 are definitely not empty so I don't know what is wrong. Any suggestions? This and the 3 flies that won't leave me alone are really starting to upset me.


    Thanks for any help!
    Last edited by timjeven; 08-11-2015 at 06:25 PM.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Can't paste to next empty column

    Does this work?
    Please Login or Register  to view this content.
    [
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    01-30-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Can't paste to next empty column

    Holy smokes, it worked! Thank you very much. Just curious why it worked as it was for so long and suddenly didn't....

    Anyway, thanks for the quick reply and helpful answer.

+ 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. Copy data and paste to another column incrementing that column to next empty cell
    By edens2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2015, 11:43 AM
  2. [SOLVED] Paste formula to the last empty cell based on a non-empty cell on another column
    By bhenlee in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-02-2015, 04:07 PM
  3. [SOLVED] Copy and paste values in column range into first empty column to the left
    By gbatz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-15-2014, 06:59 PM
  4. [SOLVED] Copy all cells in column that contain data & paste to first empty row of another column.
    By BPSJACK in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-02-2014, 08:45 AM
  5. Copy/Paste to Next Empty Row Overwriting Previous Row When Column A Is Empty
    By grantfitz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 04:34 PM
  6. copy & paste last column from pivot table to next empty column
    By kitrak2 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2013, 06:57 PM
  7. Vba - find next empty column, insert column, copy paste values & copy paste formulas
    By DoodlesMama in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2012, 12:43 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