Category: excel blog

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

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

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.