vba Archives - IT Nursery

excel, Programming

IT Nursery

Error in finding last used cell in Excel with VBA

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 ...

June 3, 2022
0 Comments

excel, Programming

IT Nursery

Excel VBA – exit for loop

I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the ...

June 1, 2022
0 Comments

Programming, vba

IT Nursery

Difference between Visual Basic 6.0 and VBA

What is the difference between the two. I always thought VBA is somewhat ‘crippled’ version of VB, but when a friend asked me ...

May 28, 2022
0 Comments

excel, Programming

IT Nursery

What is the difference between .text, .value, and .value2?

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

May 28, 2022
0 Comments

Check if a string contains another string

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 ...

May 21, 2022
0 Comments

Loop through files in a folder using VBA?

I would like to loop through the files of a directory using vba in Excel 2010. In the loop, I will need: the ...

May 21, 2022
0 Comments

Does VBA have Dictionary Structure?

Does VBA have dictionary structure? Like key<>value array? 11 Answers 11

May 18, 2022
0 Comments

Where does VBA Debug.Print log to?

Where does Debug.Print output messages? 2 Answers 2

May 15, 2022
0 Comments

How to return a result from a VBA function

How do I return a result from a function? For example: Public Function test() As Integer return 1 End Function This gives a ...

May 15, 2022
0 Comments

How to comment and uncomment blocks of code in the Office VBA Editor

In the VBA editor of Office (ALT + F11), how do you comment or uncomment a block of code? 9 Answers 9

May 14, 2022
0 Comments