Konvert Row Range in excel to be Array Format in macros

[ays_punk]

I have a formula that's only work when "Y" and "X" is on column range or array format,
but the problem is my data source on excel taken by inputbox (userform) is with row range.

Please Login or Register  to view this content.

example
y = range("E5:I5") ==> select this range use inputbox
x = range("E6:I6") ==> select this range use inputbox

my question is how to convert range rows data to array format?
execute the formula or convert data in macros. so, my excel only for data source

Appreciate if you can help me to made macros codes

[HaHoBe]

Hi, ays_punk,

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

Ciao,
Holger

[ays_punk]

I'm sorry for my mistake..
below is the link of my discussion on other forum

http://www.ozgrid.com/forum/showthre...421#post670421

Thanks to inform me about the rule.

[abousetta]

You can convert a range to a two-demsional array by using the equal sign

Please Login or Register  to view this content.

This will give you a 2D array with lbound(1) to ubound(100) for the first dimension and 1 to 1 for the second dimension.

If you want to convert this to a 1D, you can use index or application.transpose:

Please Login or Register  to view this content.

Hope this helps.

abousetta

[ays_punk]

Thanks abousetta, I've already tried this code but couldn't applied to my case.

To make it easy to understand about my problems,
i will upload my workbook,
please run my user form, the step as follow:
1. select data P by text box to excel worksheet "acak2" sheet, example "E5:AZ5"
2. same for data Q, select range "E6:AZ6"
3. skip for input P (i already decide this value on code)
4. click command button "Hitung" to calculate/process.
5. the result of text box a1 should be "0.000134904"

my current condition is when i follow these step, i got the result a1 is "0"
based on my analysis, i have made a wrong array, because the array on below scrip only show one value (last array)

Please Login or Register  to view this content.

I guess i have made a wrong loop to get all the array data extracted from selection range on excel.

[nilem]

Hi ays_punk,
try it

Please Login or Register  to view this content.

And also use the UserForm_Initialize instead of UserForm_Activate

[ays_punk]

Thanks a lot Nilem, you make my complicated code being a simple one,
It's work, you save my time