+ Reply to Thread
Results 1 to 2 of 2

Copy Range to other workbook on next empty row (only visible rows, include hidden columns)

  1. #1
    Registered User
    Join Date
    04-18-2013
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    37

    Copy Range to other workbook on next empty row (only visible rows, include hidden columns)

    Hi Excel Forum,

    I have a Workbook1 which contains multiple hidden rows & multiple hidden columns. I currently have a code to copy my specified range to Workbook2, but so far I can only either copy everything (i.e. all hidden/non-hidden) or just visible. The problem is that I only want to copy visible rows while still copying all the hidden columns.

    Here is my code so far, which copy/pastes everything in the range. (Please note the top half of the code is not relevant, but I kept it here to avoid misunderstanding.)


    Please Login or Register  to view this content.

    Thanks for any tips/advice/help!

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

    Re: Copy Range to other workbook on next empty row (only visible rows, include hidden colu

    You will probably have to loop through the range, for example.

    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)

Similar Threads

  1. Replies: 0
    Last Post: 01-15-2014, 05:17 PM
  2. Trying to define a range to include both rows and columns with
    By SamDeets in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2013, 03:47 PM
  3. [SOLVED] can only copy/select visible cells w autofilter on &hidden columns, want to copy all cells
    By JTwrk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-25-2012, 02:12 AM
  4. Copy range from multiple workbooks and include workbook name
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-05-2005, 12:05 PM
  5. [SOLVED] COPY - *want* to include hidden columns
    By Eric in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-26-2005, 09:05 AM

Tags for this Thread

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