Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtered Mode Copying and pasting as value yield as error?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtered Mode Copying and pasting as value yield as error?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste area not same in filtered mode . | Excel Discussion (Misc queries) | |||
#N/A error with Yield formula | Excel Worksheet Functions | |||
Error when using Yield in Excel 2007 VBA | Excel Worksheet Functions | |||
Yield fomula error #Name? | Excel Discussion (Misc queries) | |||
Pasting on Filtered Data Sheets without pasting onto hidden cells | Excel Discussion (Misc queries) |