ChrisB

ChrisB has asked 14 questions and find answers to 25 problems.

Stats

About

I'm a private sector CPA. I fast, efficient and consistent processes that just work. I regularly work with VBA (in Excel, Outlook and Word), NetSuite workflows and AutoHotKey.

ChrisB questions

How can I load a VBA library reference and use it in the same procedure?
How do ActiveSheet, ActiveWorkbook.ActiveSheet and Application.ActiveSheet behave differently?
excel vba freeze pane without select
Whats the difference between WorksheetFunction.IsNumber() and IsNumeric() in VBA?
What is the distinction between a CommandButton's .caption and .text properties in VBA?
What are the benefits and risks of using the StrPtr function in VBA?
Determine if an Excel workbook has ever been saved?
Can an array be declared as a constant?
How can ActiveSheet, ActiveWorkbook or ThisWorkbook be set as the default for an optional parameter in VBA?

ChrisB answers

Custom Excel Ribbon background colors (like design with tables)
How can i get actual used range for modified excels using Epplus?
How do I reference a cell within excel named range?
Check whether an Excel Range represents entire row or column
Refresh All Queries in Workbook
Excel Return Table name using Formula?
Get the Windows Download folder's path
How to determine if a worksheet Cell is Visible/Displayed in VBA?
VBA Worksheet change event bypass?
Excel data validation with suggestions/autocomplete