Pass values of UserForm TextBoxes to 2D Array

Hi all,

I need to pass values from my UserForm's TextBoxes to a Named Range as a two dimensional array and it just doesn't seem to work!!

I am using below code to get the values

Please Login or Register  to view this content.

My UserForm is created dynamically and looks as follows:

fdsfds.PNG

When I run the code I would get errors if the textbox is blank, hence I used "On Error Resume Next". With such error handling it creates the following named array:

Please Login or Register  to view this content.

It somehow seems to "ignore" the first two columns "PF" and "FAL", but I don't know why??

If I instead use

Please Login or Register  to view this content.

It works just fine, but it's not a two dimensional array

I want to use such named array to get certain values in my workbook formulas

e.g.

Please Login or Register  to view this content.

result = 75

You're only specifying one dimension when populating the array - use both:

Please Login or Register  to view this content.

And move the Redim so it's before your loops.