I would generally avoid using `Range("A" & Rows.Count).End(xlUp)` in favour of `Application.Intersect(MySheet.Range("H:H"),MySheet.UsedRange)`. I would also typically suggest you use arrays rather than looping over individual cells like this. Criticisms aside, it's good you suggest people try alternative approaches out for themselves, and super good that you uploaded these to youtube for free :) Well done
@KarenTateosyan
2 жыл бұрын
Thanks for your comment, Sancarn...there are many ways to achieve a result, I'm not saying the one I've shown is the most efficient. These are videos I recorded about 4 years ago but I uploaded them as they may help beginners in VBA.
Пікірлер: 6