typename

found this piece code and its exactly as presented. It works in the provider demo, but not in my new workbook. Error occurs at the bold red print (object define error) Sub search_and_extract_singlecriteria() Dim datasheet As Worksheet Dim reportsheet As Worksheet Dim typename As String Dim...

Guys, why doesn't this code work without the TypeName thing? Sub num() Dim FormulaTest As Variant FormulaTest = Teste.Range("A1:B2").HasFormula If TypeName(FormulaTest) = "Null" Then MsgBox "Mixed" Else MsgBox FormulaTest End If End Sub PS: I have text in A1 and a formula in B2...

Hi, I'm learning VBA via a book and have come across the following code which I do not fully understand how it works Sub SqrRootEg() Dim Cell As Range If TypeName(Selection) <> "Range" Then Exit Sub For Each Cell In Selection Cell.Value = Sqr(Cell.Value) Next Cell...