Tag: VBA

VBA Macro to Split Single Excel file into Multiple Excel Files basis any row count

By on • ( 15 Comments )

Dear Readers,  A strong command in MS Excel is one of must have skill for every professional but an expertise in VBA is a lifesaver. Recently, I encountered a common situation where a platform had a limitation of accepting excel files with no more than 1000 rows. This […]

VBA Basics – Part 1

By on • ( 1 Comment )

Dear Readers, VBA stands for Visual Basic for Applications an event-driven programming language from Microsoft. The Birth story of VBA VBA was derived from Visual Basic. The story of the birth of VBA began in 1991 when Microsoft partnered with Alan Cooper from Tripod under the project code named as “Ruby“. Microsoft decided […]