Convert column alpha to numeric
Function used to convert column alpha to numericAuthor: michael@excelexperts.co.uk
Convert column alpha to numeric Read More »
Function used to convert column alpha to numericAuthor: michael@excelexperts.co.uk
Convert column alpha to numeric Read More »
Function used to convert column numeric to alpha.Author: michael@excelexperts.co.uk
Convert column numeric to alpha Read More »
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
Search for specific header column Read More »
Function used to concatenate all the values in a given rangeAuthor: michael@excelexperts.co.uk
Concatenate all values in a range Read More »
Determines if a path exists anywhere on network.Requires full pathAuthor: michael@excelexperts.co.uk
Path exists on network? Read More »
Determines if a file exists anywhere on network.Requires full path & filenameAuthor: michael@excelexperts.co.uk
File exists on network? Read More »
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
Return date of the last save. Read More »
Delete all pictures from active worksheet.Author: michael@excelexperts.co.uk
Delete all pictures Read More »
Makes all named ranges in the active workbook visible.Author: michael@excelexperts.co.uk
Make all named ranges visible Read More »