Thanks combo
I tried to do what you said, but I am not sure if i do it right.
There is not really other code before this procedure to look at. I noticed that sometimes most of the range, that should show formulas, has turned to values. BUT not all cells in the range and not ALL the time...
Hi Gavin,
My calculate is on manual. It seems to happens during calculate.
Pressing F9 in edit mode doesn't do anything. Should it? Edit mode is the same Design mode,right?
Just beginning...love to learn from you.
Thanks for replying.
The cell format is general, number.
Thanks Combo for your idea. It is interesting. I tested your code. On the changes, the Msgbox will sometimes give me the entered formula, but then when I go look in the offending cell, i still find the value. Other times your msgbox will give me the value...
Hi
For the green error alert, you can take off the background error checking option in 'Excel options - formulas - Error checking'
For the textbox problem, to set value to number I use this solution. It works fine for my need.On an 'exit' event in the textbox I put this code ('ArtPu' =...
Hello Skip,
Thank you for answering my question.
Here is an example:
I run the following code through a commandbutton:
Range("FcTtc").FormulaR1C1 = "=FcTotHt+FcPort+FcTotTva"
Range("FcTotHt").FormulaR1C1 = "=SUM(DetC08)"
Range("FcTotTva").FormulaR1C1 = "=SUM(DetC10)"...
Hello,
In my more complicated excel files, where I use Vba to set formulas it happens that certain cells seems to switch directly after the imput of the formula, to merely the result of the formula. It looks as if the cell was treated with a Copy.PasteValues command.
It seems to happen to only...
Hello,
I have the following code for exporting a range as Pdf:
FcFile = Range("FcFile").Value
FileX = ActiveWorkbook.Path & "\" & "Sales" & "\" & FcFile & ".pdf"
Range("Invoice").Select
Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:=FileX, Quality:= xlQualityStandard...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.