Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Pasting Visible data only

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    765
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a worksheet that has hidden columns and I want to copy and paste only the visible data, is this possible ?

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-04 15:31, Peter100 wrote:
    I have a worksheet that has hidden columns and I want to copy and paste only the visible data, is this possible ?
    Just select the range to copy.

    Select from Menu: Edit > Goto > Special

    Then select Visible cells Only in the Goto
    box.

    Press Copy then goto the area you want to paste and Paste.

    You should only have the Visible cells


    _________________

    Kind Regards,
    Ivan F Moala
    Have a Nice day

    [ This Message was edited by: Ivan F Moala on 2002-05-04 15:41 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Brisbane, Down Under
    Posts
    542
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Peter the vba code for this is
    Selection.SpecialCells(xlCellTypeVisible).Select
    ActiveSheet.Paste



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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