David Gul, Author at ExcelGurus

Speed Up a Slow Excel Workbook Without Rebuilding It

A slow workbook can usually be made fast without changing how it looks or works: an Excel VBA developer finds

Supplier invoices that arrive as PDFs can go into Excel without retyping: an Excel VBA developer builds a workbook that

An Excel VBA program can check the due dates in your workbook every day, prepare the reminder emails in Outlook

Run-time error 1004 is Excel’s general refusal: VBA asked Excel to do something with a range, a sheet or a

When an Excel macro that used to work suddenly stops, the cause is usually outside the code. Something around it

To format phone numbers in Excel all the same way, strip each one down to its digits, drop a leading

To split an address such as “1200 Maple Grove Ln Apt 4B, Springfield, IL 62704” into four columns, count the

To find invalid email addresses in Excel, put a check formula beside the column and filter for FALSE. In Microsoft

To convert a quote to an invoice in Excel, build the invoice from the quote instead of retyping it: one

To track overdue invoices in Excel, keep payments in a table of their own, and let formulas work out each