RichardMGreen
Well-known Member
- Joined
- Feb 20, 2006
- Messages
- 2,177
Hi all
I've got a fairly complex workbook that contains a lot of macros and a userform.
On the front sheet, there are various cells with formulas in them.
One cell in particular keeps having it's formula overwritten by the fixed value and I can't see why.
There also seems to be no pattern to when it happens (I've tried trapping the change to see if I can see what I've just done but that's not helping).
I've checked all my macro code and that cell isn't mentioned anywhere so I don't thin it's anything to do with the userform but I'm not ruling that out completely).
Bizarrely, it can also happen when I change a validated cell (this one contains times) but there's no code attached to that sheet.
Before I throw the whole thing out and start again, can anyone suggest what I can do to try and track this down please?
One small point that may be a red-herring......
The userform did (before I changed it) write directly to the cell in question.
I've made sure that it's all been updated to the new cell but I'm not sure if it's got a bit scrambled somewhere........
I've got a fairly complex workbook that contains a lot of macros and a userform.
On the front sheet, there are various cells with formulas in them.
One cell in particular keeps having it's formula overwritten by the fixed value and I can't see why.
There also seems to be no pattern to when it happens (I've tried trapping the change to see if I can see what I've just done but that's not helping).
I've checked all my macro code and that cell isn't mentioned anywhere so I don't thin it's anything to do with the userform but I'm not ruling that out completely).
Bizarrely, it can also happen when I change a validated cell (this one contains times) but there's no code attached to that sheet.
Before I throw the whole thing out and start again, can anyone suggest what I can do to try and track this down please?
One small point that may be a red-herring......
The userform did (before I changed it) write directly to the cell in question.
I've made sure that it's all been updated to the new cell but I'm not sure if it's got a bit scrambled somewhere........