Filtering, Copy and Paste

**shaylev** · 05-09-2012, 08:10 PM

Hi,

I have this problem I have been working on and I can't seem to figure out why it doesn't work properly.

This is what I am doing using VBA code:

1. auto filter a "data sheet" with about 5000 records
2. after filtering i am coping one column from the "data sheet"
3. pasting the copied data into "new sheet"

The problem is that I am not getting all the records. If I filter the "data sheet" manually I get 728 records (after the filtering) but when I use the code after the copy and paste is done I get only 693 records in the "new sheet".

Does anyone know why?

I can include the code if that will be needed.

Many Thanks,
Shay

**davesexcel** · 05-09-2012, 08:15 PM

What code are you referring to?

My assumption is that the range is hard coded.

**shaylev** · 05-09-2012, 08:22 PM

Hi Davesexcel,

Thanks for the quick reply.

You are correct. The range is hard coded. Is there a different way that I should be doing this?

Here is part of the code:

Please Login or Register  to view this content.

Thanks,
Shay

**davesexcel** · 05-09-2012, 08:30 PM

If you have 5000 rows then you should be copying 5000 rows not 500, the code will only copy the visible cells anyway.
You destination range should just be A1, not A1:A500

More clarification can be achieved if you attach a sample workbook.