+ Reply to Thread
Results 1 to 1 of 1

Paste array into filtered range

  1. #1
    Forum Contributor
    Join Date
    07-13-2017
    Location
    Hong Kong
    MS-Off Ver
    MS Office 365
    Posts
    477

    Paste array into filtered range

    Hi all,

    I'm using below code to concatenate 3 columns on a sheet and then paste the concatenated array back in column A. This works great if all columns are unfiltered, however, if they are not, it does take all values from the sheet (which it should) but when pasting it back in column A, it seems to only paste it in the visible cells rather than every cell. How can I paste it to all cells including the "hidden" ones without unfiltering first?

    Please Login or Register  to view this content.
    Last edited by esbencito; 08-04-2019 at 11:38 PM.

+ 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. TO paste data in filtered range..
    By Vivek2705 in forum Excel General
    Replies: 6
    Last Post: 01-22-2019, 01:39 PM
  2. Creating an Array from range, no duplicates, filtered by location
    By gottnoskill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-13-2015, 10:14 AM
  3. Copy paste filtered range with criteria using VBA
    By Jayant shettigar in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-12-2014, 10:26 AM
  4. Help! - Range = Array when ranges is filtered is not working
    By gsmcconville in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-01-2014, 11:42 PM
  5. [SOLVED] Add Auto Filtered Non Contigous range to Array
    By Foreverlearning in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-26-2012, 04:27 AM
  6. [SOLVED] Add Range to Array find Array value and Paste back to Range
    By Foreverlearning in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-28-2012, 05:45 PM
  7. paste over a filtered range
    By freddie2711 in forum Excel General
    Replies: 8
    Last Post: 04-27-2005, 09:06 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