General

Function used to convert column alpha to numericAuthor: michael@excelexperts.co.uk

Function used to convert column numeric to alpha.Author: michael@excelexperts.co.uk

Function used to return column NUMBER from range.‘rng’ is the range containing the header sought‘hdr’ is the string being sought, and is CASE SENSITIVEAuthor: michael@excelexperts.co.uk

Function used to concatenate all the values in a given rangeAuthor: michael@excelexperts.co.uk

Determines if a path exists anywhere on network.Requires full pathAuthor: michael@excelexperts.co.uk

Determines if a file exists anywhere on network.Requires full path & filenameAuthor: michael@excelexperts.co.uk

Returns the data of the last save osf the active workbook.Can be used as a formula in a worksheet.Author: michael@excelexperts.co.uk

Delete all pictures from active worksheet.Author: michael@excelexperts.co.uk

Makes all named ranges in the active workbook visible.Author: michael@excelexperts.co.uk

Delete all shapes from active worksheet.Author: michael@excelexperts.co.uk