VBA – Excel – Determine and set data range
Use: Ron De Bruin: http://www.rondebruin.nl/win/s9/win005.htm Last Function: Function Last(choice As Long, rng As Range) ‘Ron de Bruin, 5 May
Read moreVBA – Excel
VBA – Excel – Tips on Learning VBA
Every now and again I am asked what is the best method to learn VBA. On this topic here are
Read moreVBA – Excel – Count the Number of Matching Words in Two Strings
Possibly useful to sort, order or compare lists of non-identical but related strings.
Read moreVBA – Excel – Routine to position shapes in range
Routine to position shapes in worksheet based on specified ranges. Note: Can use ‘print shape name‘ routine to create required
Read moreVBA – Excel – Print All Shape Names Routine
Routine to list names of shapes in specific worksheet or current workbook. Can make adjustments here to list various shape
Read moreVBA – Excel – Routine to Show All Worksheets (ie Make visible)
When there are a lot of hidden worksheets, making them visible one by one can be a pain. Stick this
Read moreVBA – Excel – Reference list
Great page on referencing pivot table ranges – shows the range selected for each selection method used http://www.globaliconnect.com/excel/index.php?option=com_content&view=article&id=154:referencing-an-excel-pivot-table-range-using-vba&catid=79&Itemid=475 Excel Chart
Read more
VBA – Excel – Lookup Range
Function to return a value for a specific id from a dataset with column headers in the first row (ie
Read moreVBA – Excel – Simple PivotTable Report
Simple PivotTable report to show basic information about PivotTables in the activework. Useful in tracking down lost PivotTables and other
Read more
The Lost Boarding Pass puzzle
The puzzle: One hundred passengers are about to board a plane. The first passenger lost his boarding pass and decides
Read more