View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
aligahk06 aligahk06 is offline
external usenet poster
 
Posts: 3
Default 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