Paste Values based on cell value

[lyla22]

Hello,

I would like to paste the formulae in specific rows with values, if specified in a cell. I've attached an example of the scenario and would appreciate any help.

Thanks

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.

[bmouse]

Could you be mor specific, please?

Condition:
If "Y" is entered in Column F, then replace that rows formulae with values. You mean replace the values of the cells in that row with some other values? What values?

[lyla22]

Hi Richard,

This works great.

Would there be a way of having it that as soon as the user has typed 'Y' and presses enter, that the macro would fire. I tried putting the code into a Worksheet, Selection Change macro but no joy.

Thanks.

[lyla22]

Hi,

It's to replace the formulae with their resulting values, i.e. get rid of the formulae but keep the values.

thanks

[Richard Buttrey]

Hi,

If you want the macro to fire each time a Y is entered then the code is even simpler. But use the Sheet Change event. i.e.

Please Login or Register  to view this content.

[lyla22]

Hi,

If you want the macro to fire each time a Y is entered then the code is even simpler. But use the Sheet Change event. i.e.

Please Login or Register  to view this content.

This is working well.

However, something that's causing a problem is when for example, I insert new rows/columns into the list, a debug runtime error 13, type mismatch dialog appears.

Is there any way to stop this happening?

[Richard Buttrey]

Hi,
Try this to trap the situation when more than column F is involved such as in an insert row.

Please Login or Register  to view this content.

[lyla22]

Hi,
Try this to trap the situation when more than column F is involved such as in an insert row.

Please Login or Register  to view this content.

Thanks Richard, this works great!

[Richard Buttrey]

My pleasure and thanks for the rep.