Hi Everyone,
I am trying to learn the basics of VBA to automate basic repetitive work tasks.
When attempting to declare variables and use them I keep getting a runtime error 438.
I am sure this is a vary basic format error, but I have not found any support on how to resolve the issue.
Any help is greatly appreciated.
Code Snipit: Applied to Sheet1 in VBA module
Public Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Test1 As Long
Dim Test2 As Long
Test1 = Range("D3").Vaule <---- Debugger shows the error on this line
Test2 = Test1 + 30
Range("E12").Vaule = Test2
End Sub
Thanks,
Bradley Wolosz
I am trying to learn the basics of VBA to automate basic repetitive work tasks.
When attempting to declare variables and use them I keep getting a runtime error 438.
I am sure this is a vary basic format error, but I have not found any support on how to resolve the issue.
Any help is greatly appreciated.
Code Snipit: Applied to Sheet1 in VBA module
Public Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Test1 As Long
Dim Test2 As Long
Test1 = Range("D3").Vaule <---- Debugger shows the error on this line
Test2 = Test1 + 30
Range("E12").Vaule = Test2
End Sub
Thanks,
Bradley Wolosz