January 2017 – Dale's Take

WordPress – Adding programming code to a post

dradma January 11, 2017May 25, 2019 0 Comments wordpress, programming

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

Programming VBA - Excel

VBA – Excel – Routine to Show All Worksheets (ie Make visible)

dradma January 11, 2017February 16, 2017 0 Comments excel, VBA, worksheets, visible

When there are a lot of hidden worksheets, making them visible one by one can be a pain. Stick this

Programming VBA - Excel

VBA – Excel – Reference list

dradma January 9, 2017September 16, 2017 0 Comments

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