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 moreConfigure local server to use cloud service
Here I describe my own local server setup which uses XAMPP, MySQL and OneDrive. Using a local server to manage
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 moreWordPress – Adding programming code to a post
Documentation covers this in detail: https://en.support.wordpress.com/code/posting-source-code/ Notes: Use ‘Text’ tab in post editor to avoid unnecessary formatting tags being added
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 moreWordPress – Mistake # 1 – Skip the child theme
Selecting a theme is sooo easy and don’t they look great? Being a more functionally focused kind of guy, having
Read moreWordPress – First impressions
WordPress: initial thoughts… There is no shortage of content I would like to add to the net and thus the
Read more