This bit of code will count how many formulas you have used in a workbook, will display a message box of the count and the workbook name! Enjoy! Sub FormulaCount() Dim ws As Worksheet Dim rCheck As Range Dim lCount As Long On Error Resume Next For Each ws In Worksheets Set rCheck = Nothing […]
Table Formula
Here is a simple way to target a cell’s value and divide by 7 cellv(col-3,row)/7 This will target the 3rd column from where i placed he formula column. Target a cell above, and show that value without any calculations (cellv(col,row-1)) Table formula break down Formula 1 – Shows totals for the row, as only 2 fields Type […]
First and Last date of the last month
First and Last date of the last month Extract just month from a cell – Here’s how Adding years, months or days to a date – Here’s how These bits of code will display the first and late date of the last month. Pretty handy for “Last Month” reporting needs. Today is 20/02/2017 Start of last […]