Paste previously copied values as 123 except last one and...

Try and comment

Please Login or Register  to view this content.

Hi PCI,
thanks for your help, basically this code does what i want except when it pasted values it also cached the "U2" cell where the formula was located,
when i press button second time it dragged down the values which is in "U2" cell.

Maybe it is possible to exclude the cell "U2" of being pasted as a value?

Thanks for your time PCI.

Please Login or Register  to view this content.

If you just want U2 to stay with a formula just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Hi PCI
i was thinking about that, but afraid if database will exceed over 100000 records how slow its going to be?
maybe it is possible that it identifies where that last row with formula was which is "LastRow -1" and starts dragging from there?
in other words if it was dragged from cell U2 till U100 it will know that next time it should start dragging from U100, because by using your code cells U2 - U99 will be pasted as values.

I think I start to understand
See how it works

Please Login or Register  to view this content.

It works perfect, you are genius PCI !!!
Maybe you can explain me how that works? if not then ok i still very appreciate your help.

Thank You

See some quick comments

Please Login or Register  to view this content.