Objective: to load 700 X 2 range into an array. This array is thereafter loaded to a 2 column listbox which will be used to select the row in listbox and copy selected listbox value into a particular cell.
Error line is in red. This code is within Userform_initialize procedure.
What has been tried and tested?
1. Using Immediate Window, I have found values for prj(1,1), prj(2,1) etc. to be valid and consistent with table.
2. Ubound and Lbound is correct for row and col's start and end.
Please Login or Register to view this content.
Bookmarks