Results 1 to 4 of 4

Thread: [RESOLVED] Replacing a filtered range

Threaded View

  1. Feb 15th, 2007, 01:31 PM #1
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Resolved [RESOLVED] Replacing a filtered range

    I have a macro, which as the last step, has to take a column from a workbook and replace another in the active workbook. For this I simply use
    WorkBooks(workboook1).WorkSheets(sheetx).Range("X1:X111").Value=WorkBooks(workboook2).WorkSheets(she etz).Range("Z1:Z111").Value

    It worked perfectly. But I have just discovered that it doesn't work if I have initially filtered some value in the "sheetx". How can I replace a whole range even if part of this range is filtered?
    Last edited by Fonty; Feb 16th, 2007 at 03:28 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width