by Essential Excel | Nov 2, 2016 | Tips and Tricks
VBA Code to Unlock a Locked Excel Sheet With Password irst open VBA editor with Alt+F11. Double click on sheet that you want to unlock. Paste code below into editor and run macro. That’s it. Sub PasswordBreaker() 'Breaks worksheet password protection. Dim i As...
by Essential Excel | Nov 1, 2016 | Tips and Tricks
Extract Number in String Vba function val() have property that help you to extract number from string. Here is code and exampe: Function ExtractAmount(data As String) As Variant Dim s As String s = Split(data, "$")(1) 'part after first dollar sign s =...
Recent Comments