Monday, February 22, 2016

How to test a code line in VBA without creating a new module: Immediate window + Debug.print

Labels:
In order to test your code,

Sub create_array()
newarray = Sheets("Sheet1").Range("A1:B10").Value
MsgBox newarray(6, 2)
End Sub



Created by DoMyExcel.com © | Excel & VBA Consulting | Customized Excel Solutions starting at 29 USD
Services provided to Individuals and Businesses | Free Quote: DoMyExcel@gmail.com

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)