Category: VBA Class

VBA Class

An Excel VBA Macro To Report Hidden Rows

Many Excel users collaborate with co-workers and share data in Excel workbooks. Often, someone may choose to hide a row of data on a worksheet and you’d never know that a row was hidden without careful visual inspection of every row. If a hidden row contains zero values there is no issue. However, if a …

Continue reading

VBA To Add IfError Functions To Every Formula On Every Sheet

VBA To Add IfError Functions To Every Formula On Every Sheet Today we found some useful code here we wanted to share with our readers … a macro to automatically add an IfError function to every formula on every sheet in a selected workbook, assuming there was not already an IfError function used. Remember that …

Continue reading

VBA Classes Launches Online Webinar

We are pleased to announce that our new exclusive series: The Excel VBA Webinar – is now available online. Our Excel VBA classes begin once a month at different start times. Each session lasts two hours and includes no less than 30 minutes of homework to practice between sessions. In total the classes run for …

Continue reading

Excel VBA Tutorial – Learn To Use VBA To Overcome Macro Recorder Limitations

If you record a macro where you sort your data, the macro records the last contiguous row in the data set. Next time you run the macro, if you have more rows of data the recorded macro won’t correctly sort to the new last row. Also, anytime you record a macro to sort data, the …

Continue reading

Excel VBA Class Favorite Keyboard Shortcuts To Help You Save Time With Microsoft Excel

Excel VBA Class shares some of our favorite Excel keyboard shortcut techniques. The list of Excel keyboard shortcuts is not meant to be exhaustive, but we believe it offers some of the most common and frequently used shortcuts to save you substantial time and effort when using Microsoft Excel.

VBA Class NYC Custom Table Styles Free Excel Tutorial

VBA Class offers a free Excel tutorial on how to create a custom table style. To learn Excel VBA in NYC, call us at 212.828.7089 to discuss your Excel training objectives.