View Full Version : Copy and Paste in Filter
krishhi
04-20-2010, 06:53 AM
Hi,
Is there any way to copy and paste the formula into values in the same cells in Filter Mode?
Waiting For you reply
Thanks,
krrish
lucas
04-20-2010, 06:59 AM
.SpecialCells(xlCellTypeVisible).Select
krishhi
04-20-2010, 07:04 AM
@ lucas
Thanks for the reply.
But I want go through without VBA. :)
Is there Anyway?
lucas
04-20-2010, 07:21 AM
Maybe after you copy, select the cell where you want to paste and right click. Select paste special and make sure the values button is selected.
krishhi
04-20-2010, 08:19 AM
Maybe after you copy, select the cell where you want to paste and right click. Select paste special and make sure the values button is selected.
@Lucas
Ya, I tried but the data with Filter, so, i got an error message.
lucas
04-20-2010, 08:21 AM
what was the error?
did you select more than one cell to paste to?
krishhi
04-20-2010, 08:30 AM
what was the error?
did you select more than one cell to paste to?
@lucas
yes, i selected more than one cell.
lucas
04-20-2010, 08:39 AM
so it works if you only select one cell, right?
krishhi
04-20-2010, 08:47 AM
so it works if you only select one cell, right?
@lucas
See the Attached Image for better understand. :)
lucas
04-20-2010, 09:01 AM
Yes, you selected from A2 to C4 and it's not the right size.
Did you read the error message? It very clearly says at the first bulleted point to select a single cell. then paste.
krishhi
04-20-2010, 09:09 AM
Yes, you selected from A2 to C4 and it's not the right size.
Did you read the error message? It very clearly says at the first bulleted point to select a single cell. then paste.
@Lucas
I know, it's not possible.
Just i am looking for any tricks for my problem. so, i need to deselect the filter and then copy and paste the values then filter again.
Anyway thanks for the time.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.