Prev: Spreadsheet changing currency format
Next: Pivot Table - Group by Date Excel 2007
From: aligahk06 on 15 Mar 2010 09:14
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
From: arrier on 15 Mar 2010 11:30
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
 | 
Pages: 1
Prev: Spreadsheet changing currency format
Next: Pivot Table - Group by Date Excel 2007