ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Hi,
Ive been working on trying to find out why formula in two columns is removed when i leave the cell.
I have supplied a file which can be looked at.
SAMPLE FILE
The columns in question are D & F & have IF statements in them.
Column E also has a IF state there but isnt affected
I started off removing all the code for the worksheets all aprt from the one left in the file.
The issue was still present.
I then deleted all the other worksheets.
The issue was still present
I deleted basically evertyhing as i tested before & after deleting.
The issue was still there.
So apart from the one worksheet im now wondering what is causing it as the issue is still there.
Please if you have time take a look & see if anything springs to mind
Thanks
Ive been working on trying to find out why formula in two columns is removed when i leave the cell.
I have supplied a file which can be looked at.
SAMPLE FILE
The columns in question are D & F & have IF statements in them.
Column E also has a IF state there but isnt affected
I started off removing all the code for the worksheets all aprt from the one left in the file.
The issue was still present.
I then deleted all the other worksheets.
The issue was still present
I deleted basically evertyhing as i tested before & after deleting.
The issue was still there.
So apart from the one worksheet im now wondering what is causing it as the issue is still there.
Please if you have time take a look & see if anything springs to mind
Thanks