difference between .Row & .Value

[CobraLAD]

Hi all

I am trying to get the code to work. If you have .Row, it creates the row numbers, But it must create the values, in column A. If .Row is changed to .Value there is a type mismatch error. Is there an explanation somewhere to understand it better.

Please Login or Register  to view this content.

[benishiryo]

hi CobraLAD. if your data is all filled up in A3:A10 for eg & A10 contains the value "250". then ".End(xlDown).Value" is like pressing the end key & arrow down. it will reach A10 & give you a value of 250. so your variable is "1 to 250". ".Row" will give you the row number after you press end down. so that gives you "10". hence the variable for i is "1 to 10"

is that what you need?

[CobraLAD]

yes that explains, but how do I fix the code so that it creates the folders according to the values in column A.

[CobraLAD]

I found it

Please Login or Register  to view this content.