Filtered Mode Copying and pasting as value yield as error?

A

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
 
A

arrier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy and paste area not same in filtered mode . 8
Compting 99% of a col range while autofilter is on. 1
Copy and pasting values of filtered rows 1
VALUE error after pasting html banking data 3
VALUE err calculating indirect number 5
Formula to Count and Return Most common Value in a Dynamic Named Range 1
Excel 2007 - Problem Copying and Pasting From An Auto-Filtered List 2
Copying and pasting ??? 3

Top