+ Reply to Thread
Results 1 to 4 of 4

Copy Visible cells and paste values only to visible target cells

  1. #1
    Forum Contributor
    Join Date
    08-21-2008
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Office 2007
    Posts
    255

    Copy Visible cells and paste values only to visible target cells

    I have users that copy cells from a source sheet (sometimes hidden columns) and paste to another sheet (different workbooks usually).

    Sometimes the destination sheet will contain hidden columns (not necessarily the same hiddden columns configuration as the source).

    I would like to have an event in the destination sheet to paste the source visible cells values only to the visible cells in the destination sheet.

    So what you see (visible cell values in the source) is what you get (values in visible cells) in the destination sheet.
    So as not to corrupt/overwrite destination cell formats & validation, and have source values paste into hidden destination cells.

    Any assistance would be appreciated

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Copy Visible cells and paste values only to visible target cells

    AFAIK, you can copy visible cells only but you can't paste to visible cells only, i.e. skipping the hidden cells. Paste will always work as one block, starting from the first cell.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Copy Visible cells and paste values only to visible target cells

    I agree with Teylyn
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Copy Visible cells and paste values only to visible target cells

    Nevertheless you could consider:

    Please Login or Register  to view this content.

+ 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