Search results for query: *

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...

Thanks for your help Tony. I will install it and try when I come home. Just beginning...love to learn from you. Thanks for replying.

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' =...

Thanks Tony, That helps understand it. Any idea where to find the free download that installs the PDF writer?

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...