Hello
I am getting started with VBA and what I find a bit rudimentary is that for almost everything you need to write loops.
1) Is there any better way to get all within a specific object etc, i.e. all the fields of a Pivot or all the formulas of a range without having to loop?
2) If you always need to loop, what is the best practice looping in terms of efficiency and error handling etc? I think there are while loops and for loops etc, can you provide a general structure that can be used in most cases to get all the values of an object?
Thanks!
I am getting started with VBA and what I find a bit rudimentary is that for almost everything you need to write loops.
1) Is there any better way to get all within a specific object etc, i.e. all the fields of a Pivot or all the formulas of a range without having to loop?
2) If you always need to loop, what is the best practice looping in terms of efficiency and error handling etc? I think there are while loops and for loops etc, can you provide a general structure that can be used in most cases to get all the values of an object?
Thanks!