This video introduces you to how to write code to work with sheets in VBA and shows you a few tricks with renaming, selecting and hiding sheets. Make sure you stay on the video until about 3.30 mins in as the video introduces you to the veryhidden property of a sheet.  I use this property a lot as it stops people unhiding them in the Excel interface. The video finishes by showing you how to select sheets with VBA. I hope you enjoy this video on Working with sheets in VBA – if you have found it useful or have any questions [More]
This is a smart video that shows you a great hidden features in Excel but in the process also introduces some great shortcut keys and processes. When I reviewed this video I had to pause it a one place as I had a “is that true?” moment and needed to open one of my spreadsheet to check it worked with my data – it did! It is a very short video and I will be using Ctrl A almost everyday from today onwards as I am always looking at large chunks of data in Excel! As always – please let [More]
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.