Feb 17, 2013
Most of the time we refer to a cell or a range by using it’s address, for example A1 or A1:B10. However, assigning a “name” to a cell or range provides a number of benefits, one of which is to provide a quick way to navigate around the workbook. A...
Feb 17, 2013
As this is not a tutorial about absolute cell references, if you don’t know about absolute cell references, may I recommend downloading my mini-course on the subject! The screenshot above is from a spreadsheet that is used to calculate daily expenditure on...
Feb 17, 2013
Many of the solutions that I build involve populating a drop-down list on a custom form. This is achieved using a few lines of VBA code. In most cases, the end-user wants to be able to update the items on the drop-down list without coming back to me. The easiest way...
