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

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

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

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

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

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