Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SeekExcellence

    Why do fomulas disappear and get replaced by values after using VBA?

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

    Why do fomulas disappear and get replaced by values after using VBA?

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

    Why do fomulas disappear and get replaced by values after using VBA?

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

    Why does the command Publish to Pdf (ExportAsFixedFormat) not work

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

    Problem Writing Numeric to a Cell Formatted as General

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

    Why does the command Publish to Pdf (ExportAsFixedFormat) not work

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

    Why do fomulas disappear and get replaced by values after using VBA?

    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)"...
  8. SeekExcellence

    Why do fomulas disappear and get replaced by values after using VBA?

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

    Why does the command Publish to Pdf (ExportAsFixedFormat) not work

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

Part and Inventory Search

Back
Top