Copy and Paste in Filter

[krishhi]

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]

[VBA].SpecialCells(xlCellTypeVisible).Select[/VBA]

[krishhi]

@ lucas

Thanks for the reply.

But I want go through without VBA.

Is there Anyway?

[lucas]

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]

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]

what was the error?

did you select more than one cell to paste to?

[krishhi]

what was the error?

did you select more than one cell to paste to?

@lucas

yes, i selected more than one cell.

[lucas]

so it works if you only select one cell, right?

[krishhi]

so it works if you only select one cell, right?

@lucas

See the Attached Image for better understand.

[lucas]

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]

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.