Office 2007 Filter Copy Issue

A

anshuman

Hi All,

I wrote a macro in Office 2003 which does the following task.


In a data Sheet names Total2, it filters Colum 2 using a keyword and
then copies only the filtered data onto a new sheet called
Calculation.


I used the following lines of code which was working perfectly


Sheets("Total2").Select
Selection.AutoFilter Field:=3, Criteria1:=Var3 'Var 3 keeps on
changing for each loop I run
Sheets("Total2").Select
Range("A1:FE999").Select
Selection.Copy
Sheets("Calculation").Select
Range("A1").Select
ActiveSheet.Paste


Earlier, it was copying only the filtered data...


Now, when I try running the same macro using Office 2007, the entire
data is copied irrespective of what I use as a filter.


What do I do to paste only the filtered data in the Sheet
"Calculation"


Please help


Thanks in advance,
Anshuman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office 2007 Copy Paste Issue 5
Help me4 2
Filter based on named range cell - debug help required 3
Problems copy data when using filter in place 3
How to Activate Filter in Protected Sheet 2
How do I choose the rows that are filtered ? 1
VBA Copying/Pasting problem when data is filtered 1
Copying filtered data 0

Top