Vba and Fomula conflict

Hi and thanks for taking the time to read my Post

You guys have been a Great Help so far

ok i have this code on sheet4 "HIDE" works great, but when i put a fomula =PLAYERS!B19 in D2 and =PLAYERS!C19 in E2 on
sheet4 "HIDE" the VBA code doesn't work, is there a way to make them both work?

Please Login or Register  to view this content.

Thanks
Keith

Thankyou Richard Buttrey

its probably me, but i couldn't get it to work properly at all

i couldn't copy across with the formula either, and maybe i'm wrong, but you said to E12 and
i need it to goto E21 unless it was a typo, but seriously i appreciate your help and fast response,
but unfortunately it didn't work for me , if it works for you, please send me the book back with it
working and maybe i'll learn something by seeing where you put the formula.

Thanks
Keith

Thankyou again Richard Buttrey, i love your prompt responses

i don't think i have explained myself good enough, my 1st attachment has no formulas in sheet4 "HIDE" colum D or E
but B2 and C2 would keep a running total from D2 and C2, but everytime any type of formula gets entered into
D2 or C2 the numbers don't add up anymore in B2 and C2, the code in sheet4 "HIDE" stops working.

Please Login or Register  to view this content.

Thanks
Keith