#REF! errors after running macros

[CathieW]

Hi, I hope someone can shed some light on this problem, which is driving me nuts!

I'm creating a multi tab workbook with macros, and some tabs have vlookups which point to the cells refreshed by the macros.

As these cells are deleted before being repopulated by the macro, the formula is returning a #REF! error (and the cell references in the formula all change to #REF!) - how do I set the formula to use the new information please?

If that doesn't make sense, please tell me, I'm not very good at describing problems without having someone looking over my shoulder who I can demonstrate things to!

Thanks very much
Cath

 

[Richard Schollar]

Hi Cath

Description is fine. Please can you post a sample of the formulas you are using (ie the formula text as it appears in the formula bar) and also the code of the macro that deletes the cells.

 

[pcc]

don;t delete the cells. If you want to get rid of the data then choose 'clear contents' instead. this will preserve the integrity of the data

 

[CathieW]

don;t delete the cells. If you want to get rid of the data then choose 'clear contents' instead. this will preserve the integrity of the data

You are a STAR!! Thanks so much

Cath x