Transfer a sub Table (column in a table) into VBA array

[omarehabsalama]

Hello,

How do I transfer a column in a table into an array in vba ?

as example my table is "Table2" , the sub table is [ES] , so I tried this and it didn't work:

Please Login or Register  to view this content.

and also tried this :

Please Login or Register  to view this content.

and one more question:

why in the sub when I define mx=Worksheets("sheet1").Range("AB8").Value

and then I enter the mx to a for loop as :

Please Login or Register  to view this content.

it doesn't work and say it must be constant ?!

[nilem]

try it

Please Login or Register  to view this content.

[omarehabsalama]

it didn't work :/

look, here is the file and plz be patience with me because I've been doing this project for 2 weeks now and I have to submit it tomorrow, and I still have some calculations to make in it

simply what i'm trying to do is :
calculate the total labors/material/subcontractors cost in every month (after calculating the months)
I have a total labors cost per activity and then the labor cost per day

some activities are dependent and some are independent, so I have to know every activity starts when and ends when to know if the cost will enter this month

now you have to look at the tst module

and I don't mind looking at "Activity" userform and look into the "next" bottom code, coz after I've modified some text boxes the code crushes when ever I press next

the attachment :

Project test 2_3.xlsm

[nilem]

Hi Omar,
it is very difficult to understand your problem completely
But note that this expression EESS = Worksheets("Sheet1").Range("Table2[ES]").Value gives you a two-dimensional array (13 rows and 1 column), so your code should look something like this

Please Login or Register  to view this content.

instead of this

Please Login or Register  to view this content.

Hope it will help you a little bit

[omarehabsalama]

ys it helped thx !!!

I got over it actually by another mean

I took the whole column like range("C:C")
and that is one dimensional array , but a friend of mine told me that my problem would be trying to reference a 2 dim array as a 1 dim one, and u confirmed it

so thanks again nilem