Filtered Mode Copying and pasting as value yield as error?

[aligahk06]

Dear All,

While in filtered mode copying cell that consists formula and converting them into values yield as following error.
Copy and paste area are not same so error.

Is there any code or macro that can convert the cell consisting formula into value.
Note:- The cell is in Filtered mode.

Please assist?
Rgds,
Alighak06

[Bob Phillips]

Cross-posted in the Excel public newsgroups.