PDA

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.