by Stan Amditis (3 Submissions)
Category: Microsoft Office Apps/VBA
Difficulty: Intermediate
Date Added: Wed 3rd February 2021
Rating: (4 Votes)
Demonstrates the proper way to fill an excel sheet with data from an array. Lightning fast compared to filling cell-by-cell.
Assumes
Required MS Excel 2000 or higher
API DeclarationsPrivate Declare Function BringWindowToTop Lib "user32" (ByVal hWnd As Long) As Long