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
Can't Copy and Paste when I'm using a filter List.. hmmm 1
pasting formulas 2
Error with copying values in cells 2
VALUE error after pasting html banking data 3
Copying Rows with values in column A pasting in a new doccument and saving that doc 1

Top