IT Nursery
When I want to find the last used cell value, I use: Dim LastRow As Long LastRow = Range("E4:E48").End(xlDown).Row Debug.Print LastRow I’m getting the wrong output when I put...
I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the if condition has been met? I...
What is the difference between the two. I always thought VBA is somewhat ‘crippled’ version of VB, but when a friend asked me the other day I had no...
What is the difference between .text, .value, and .value2? Such as when should target.text, target.value, and target.value2 be used? 7 Answers 7
I want to find if a string contains a “,”(comma) in it. Do we have any other option other than reading char-by-char? 5 Answers 5
I would like to loop through the files of a directory using vba in Excel 2010. In the loop, I will need: the filename, and the date at which...
Does VBA have dictionary structure? Like key<>value array? 11 Answers 11
Where does Debug.Print output messages? 2 Answers 2
How do I return a result from a function? For example: Public Function test() As Integer return 1 End Function This gives a compile error. How do I make...
In the VBA editor of Office (ALT + F11), how do you comment or uncomment a block of code? 9 Answers 9