I had the same problem and this macro worked for me,

Range("------:------").Select
Selection.SpecialCells(xlCellTypeVisible).Select
Selection.Copy
Range("------").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
End Sub




"aligahk06" wrote:

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