Today I spent time working out why I could not convert some text values I had pasted from a FR report to Excel into numbers. It turns out the text values were padded with non breaking spaces which TRIM() did
How to Protect Cells in Excel with a Macro
Occasionally I am asked to create a protected Excel workbook where users are only able to enter data into specific cells. For example, in the above sheet users can only input into cream cells. This is done by unlocking