+ Reply to Thread
Results 1 to 6 of 6

Copy filtered cells and paste them in the same place - Header error

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    17

    Copy filtered cells and paste them in the same place - Header error

    Hi guys.

    I have a problem which i cannot solve.

    In VBA code.

    I need to filter a column ("D"), select filtered cells (de-select "Blanks" from list), copy filtered data, and past them in the same place with "Paste Special Values".

    This action is intended to remove formulas from selection and paste them as values in the same place.

    Every time i try to do this, i get a message that the cells area is not the same size.

    Another way is to copy only cells with data and paste them in the same place, this way i could save the remaining formulas to the next job.

    Help Please.

    All the best

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Copy filtered cells and paste them in the same place - Header error

    Try this...

    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    01-23-2013
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Copy filtered cells and paste them in the same place - Header error

    Thank you AlphaFrog!

    Almost there, works perfectly for "D" column!!!

    But i also need to paste special values for the rest of the selection (From "A to BP columns, not only for "D" Column...

    Thanks!

  4. #4
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Copy filtered cells and paste them in the same place - Header error

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-23-2013
    Location
    portugal
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: Copy filtered cells and paste them in the same place - Header error

    Thanks a lot!!!

    It works Perfectly!!!

    Regards

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Copy filtered cells and paste them in the same place - Header error

    You're welcome.

+ 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. [SOLVED] Avoiding Copy & Paste in Hidden/Filtered Cells
    By garrett.grillo in forum Excel General
    Replies: 5
    Last Post: 02-24-2014, 04:45 PM
  2. Copy and paste data with filtered cells
    By rikkyshh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2013, 06:54 AM
  3. Replies: 3
    Last Post: 03-15-2012, 10:01 PM
  4. Copy/paste cells to word header from excel
    By scifo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2010, 03:24 AM
  5. Copy and Paste on Filtered cells
    By rlkerr in forum Excel General
    Replies: 2
    Last Post: 06-24-2009, 02:39 PM

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