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

This Week's Hot Topics

We've detected that you are using an adblocker.

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.
Go back
Top