VBA Advanced Filter clearing cells out of it's range

[GlennL]

Hello,

I am using an advance filter in VBA.

Step 1 I do a row count using xlFilterInPlace of the advanced filter
Step 2 I make the CopyToRange the same size as the xlFilterinPlace row count
Step 3 I run the advanced filter using xlFilterCopy

The problem I am having is, the cells under the CopyToRange are getting the cell values cleared.
I have tried putting these cells 1000 rows lower on the sheet, but the same thing occurs.

Anyone have come across this before and have a solution?

 

[kvsrinivasamurthy]

Click on Copy to another Location.
in Copy To select a new range for filtered output. single row with same number of columns will do.

 

[GlennL]

Hello,

I am using an advance filter in VBA.

Step 1 I do a row count using xlFilterInPlace of the advanced filter
Step 2 I make the CopyToRange the same size as the xlFilterinPlace row count
Step 3 I run the advanced filter using xlFilterCopy

The problem I am having is, the cells under the CopyToRange are getting the cell values cleared.
I have tried putting these cells 1000 rows lower on the sheet, but the same thing occurs.

Anyone have come across this before and have a solution?

Problem found, CopyToRange was set wrong