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.
Continue reading “How to screen capture of active application?”Posts
Video tutorial: How to declare Excel range in VBA?
In this video I’m going to present You my 5 simple ways of how to declare Excel range in VBA. Watch it here or go to my channel.
Enjoy the video, leave a like and subscribe to my channel!
How to make print screen of worksheet
It would be often useful to be able to take a screenshot automatically. Many times I was wondering if it is possible at all to code it. In this article I will share with You how can You make print screen of your worksheet.
Continue reading “How to make print screen of worksheet”Video tutorial: For vs For Each – which is faster?
Welcome to my next YouTube tutorial video, which is about loops comparison – For vs For each – which is faster? Watch it here or go to my channel.
Enjoy the video, leave a like and subscribe to my channel!
How to data label on pie chart?
In previous article I showed You how to create fake doughnut using pie chart. It was nice, round and tasty. But what about data labels, when You got very big and very small data on the same chart? In today’s post I’m gonna show You how to data label on pie chart.
Continue reading “How to data label on pie chart?”Video tutorial: How to get a PDF preview in Excel
Welcome to the next YouTube tutorial video, which is about how to get a PDF preview in Excel application. Watch it here or go to my channel.
Enjoy the video, leave a like and subscribe to my channel!