help with array macro

Imran Azam

Board Regular
Joined
Mar 15, 2011
Messages
103
Hello people

hope all is well

i have a group of number and i am trying to create a macro that would read these numbers into an array and also calculate the min value of each row and also store this into a new array.

is there anyone that can help me with this?

below is he group of numbers ( the range is e5 to m15)


50​
1​
2​
3​
46​
7​
2​
2​
1​
10​
3​
5​
7​
8​
9​
0​
12​
1​
20​
4​
6​
8​
9​
10​
1​
13​
2​
30​
5​
7​
9​
10​
11​
2​
14​
3​
40​
6​
8​
10​
11​
12​
3​
15​
4​
70​
7​
9​
11​
12​
13​
4​
16​
5​
71​
8​
10​
12​
13​
14​
5​
17​
6​
72​
9​
11​
13​
14​
15​
6​
18​
7​
73​
10​
12​
14​
15​
16​
7​
19​
8​
74​
11​
13​
15​
16​
17​
8​
20​
9​
75​
12​
14​
16​
17​
18​
9​
21​
10​

thank you
 
@Imran Azam you have already been told about cross posting, so please supply the link as per the rules.
 
Upvote 0

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
That would have been on the other site, not this one.
Just copy the URL from the address bar & paste it into a reply here.
 
Upvote 0
ok ( you are right as i created that second sorry)
 
Upvote 0

Forum statistics

Threads
1,214,591
Messages
6,120,428
Members
448,961
Latest member
nzskater

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top