How can I use the content of this cell now? If its hidden I can not use it and I get an error on the next cell. Because the next cell uses thisone to demonstrate the content..
If that does not answer your question, because I cannot see your image, you are going to need to do your best to explain what you have and what it is you are now trying to do.
Picture one "Hbzgi2C.png" is using the old code.
Picture two "Hbzgvcl.png" is using the new code. And it works. But on line 9 you can see that the value of column G shows #VERDI ! because now F9 is empty... Column G needs the value of F to calculate the total price...
Unfortunately, the same security policy at my workplace that blocks those images also blocks image and file sharing sites. So I cannot see those either.
Can you tell me what the formula you have in G9 is?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.