ignore formulas

  1. 4

    VBA copy but ignore blank cells that have formulas

    I have a copy button that is supposed to copy a range but only the cells that contain data and I'm currently using CurrentRegion but that doesn't ignore the cells that are blank with formulas in them. The formulas go from A1:H44 but columns A through H are merged so it's really just A1:A44...
  2. K

    Data entry question in Excel

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  3. S

    Copy paste ignoring formula returning 0

    Hi All, I have a mock-up general journal template, this will copy and paste items from sheet1 to sheet2 and increment a unique reference. I’m happy with all the functionality up to there. The issue: column B generates a reference using a formula based on entries in column G. Until a value...
  4. J

    Get Dyndamic Charts to Ignore Formula

    I'm running a chiropractic office. In order to see where I've been and where I'm going I keep track of things like new patient visits, patient report visits, cash in, insurance in, etc. I keep track of this on a daily basis on one worksheet. The weekly totals are paste-linked into another sheet...
  5. girapas

    Check if a cell has data ignoring the formula in it

    I want to enter a formula in A2 to calculate A1+10, if the B2 has data and if it hasn't to leave the cell blank. The cells B1 and B2 have formulas that update from other cell. The following formulas don't work when I use them in A2 (I suppose due to the existence of the formula in B2)...
  6. T

    ignore formulas

    I have a macro that selects all cells that have data in a column. the only problem is my cells have a formula and it selects these as well even when the formular results in "" formular in the cell is =IF(B13="","",C13&","&B13) Macro is Range(ActiveCell, (Cells(65536...

Some videos you may like

This Week's Hot Topics

  • Check VBA code to locate value in cell
    Hello this is the current code I have [CODE=vba] Private Sub TextBox1_AfterUpdate() Dim m As String Dim rx As String rx = Trim(TextBox1.Text)...
  • Reverse Numbers Formula
    Hello Everyone! My computer is Asus My Operating system is Windows 10. Can someone please help me with a formula that I can drag down (or up) to...
  • Count If Issue
    Hi all, I'm trying to create an spreadsheet which counts certain words in a cell only once and gives me a total. I can do this but some of the...
  • VBA Check for multiple cell values and copy the cell in column A
    Hello! So I have this code that checks for the values in column "L" in this case it's 25. But I want to change this code so that it actually...
  • Sending mails to specific recipients based on a cells value
    Good morning, I am trying to get excel to send out an email to different sales reps. So if row X is an error code of "999" then excel needs to...
  • Matching Number in Textbox
    Hello Excel Users, I come with a request. Hope all are doing fine. So I have 1 textbox to type in numbers etc. 12345 (it will always be 5...
Top