Video tutorial: Arrays as best Excel table alternative!

Arrays are awesome. This is one of the main things You should learn working with Excel VBA. In case of data, I think I can safely say, that arrays are the best alternative for tables in VBA. Watch it here or go to my channel.
Enjoy the video, please leave a like and subscribe!

How to screen capture of active application?

Last time I showed You how to make preview of a PDF file. Unfortunately that method puts whole file into your worksheet. In case of big size, it increases a lot the workbook weight. In this article I’m going to show You how to make it easier and lighter by screen capture of active application.

Screen capture of active application
Continue reading “How to screen capture of active application?”