Fill a cell with VBA if contents get deleted by User

[declan1983]

So this is a little convoluted:


Columns B:K
Rows 14:59

Column H has a formula in it which looks up a value based on column G - =IF(ISBLANK(C52),"",VLOOKUP(C52,'ET RATES'!$A$111:$M$122,'ET RATES'!$A$2,FALSE)) - However there will be some cases where this formula returns "Enter Cost", this will then be manually entered.

I am trying to find a way to repopulate this formula if the manually entered values are deleted. The formula is in all cells in column H.

[TMS]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

[declan1983]

I think I have uploaded a sample.

[CheeseSandwich]

How about something like:

Please Login or Register  to view this content.

Hope this helps

[declan1983]

It keeps kicking me back a type mismatch on

Please Login or Register  to view this content.

I am wondering if it is possible to just copy the formula from the first non empty cell below?

I may be barking up the wrong tree altogether and a separate sheet may be the way to go though.

[TMS]

Works for me. Have you typed the code or copied and pasted it?

[CheeseSandwich]

I reckon you could be editing more than one cell at a time, try this instead:

Please Login or Register  to view this content.