Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 8 of 8

Thread: to copy and paste, leaving out the hidden rows!

  1. #1
    Join Date
    20th February 2006
    Posts
    55

    to copy and paste, leaving out the hidden rows!

    Hello,
    Despite that I can print a sheet includes hidden rows or columns , as I can leave out those hidden columns or raws, but I can not copy from the same sheet these apparent rows and columns only , regardless those hidden columns and rows !!
    As the result (which I do not want) I've to paste all the hidden and apparentcolumns and rowsto gother.!!
    Last edited by lion; February 21st, 2006 at 04:56.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2006
    Posts
    70

    Re: to copy and paste, leaving out the hidden rows!

    Hi Lion,

    May be you can try adding 'auto-filter' to your data and try copying pasting.

    Meg

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    20th February 2006
    Posts
    55

    Re: to copy and paste, leaving out the hidden rows!

    Thank you Meg
    But in this case I do'nt think that I can solve this matter, especially that I have thousands of hidden rows !
    if only I have a choise to select the only apparent rows.!
    thank you again ..

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2006
    Posts
    70

    Re: to copy and paste, leaving out the hidden rows!

    Can you post up an example?

    Meg

    Excel Video Tutorials / Excel Dashboards Reports


  5. #5
    Join Date
    20th February 2006
    Posts
    55

    Re: to copy and paste, leaving out the hidden rows!

    hi Meg
    thank you .
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,314

    Re: to copy and paste, leaving out the hidden rows!

    Hi,

    Try this.
    VB:
    Sub MyCopyPaste() 
         
        Dim rngCopy As Range 
         
        With Worksheets("Copy from") 
            Set rngCopy = .Range("A1:F" & .Range("A" & Rows.Count).End(xlUp).Row).SpecialCells(xlCellTypeVisible) 
        End With 
         
        rngCopy.Copy 
        With Worksheets("paste to") 
            .Activate 
            .Range("A1").Activate 
            .Paste Link:=True 
        End With 
    End Sub 
    
    

    Cheers
    Andy


  7. #7
    Join Date
    24th January 2003
    Location
    Australia
    Posts
    31,708

    Re: to copy and paste, leaving out the hidden rows!

    To do this manually, select the range to copy (including hidden rows) and push F5 then click Special and check Visible cells only - Ok. Now copy/paste

  8. #8
    Join Date
    20th February 2006
    Posts
    55

    Re: to copy and paste, leaving out the hidden rows!

    Hi Andy,
    Hi Dave,
    I'm real grateful to you both,
    your idia is very great Dave.
    thank you.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Paste data and skip hidden rows [Solved, mostly]
    By Barwick in forum EXCEL HELP
    Replies: 7
    Last Post: February 18th, 2014, 17:49
  2. Copy Hidden Rows & Keep Hidden When Pasting`
    By simmon in forum EXCEL HELP
    Replies: 1
    Last Post: June 8th, 2007, 21:25
  3. Copy And Paste Rows
    By SuziQ in forum EXCEL HELP
    Replies: 6
    Last Post: May 4th, 2007, 00:49
  4. copy skipping hidden rows or hidden columns value
    By ilyaskazi in forum EXCEL HELP
    Replies: 4
    Last Post: February 25th, 2006, 17:13
  5. Copy and Paste 30,000 rows down....
    By ilcaa in forum EXCEL HELP
    Replies: 2
    Last Post: June 23rd, 2005, 02:43

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
  •  
porno