Hi, I'm rather new to VBA and EXCEL, I like to think I'm not an idiot but.... I'm stumped.
I intigrated an array function i found online into a spreadsheet I'm using. I want to pass a variable cell range into that array formula and have it auto fill on my spreadsheet.
I can get the code to work with set numbers (10) but not with the variable range. See below.
The array function takes the range you want to randomly select from and the number of unique values you want to return.
where you see: "=randsfromrange(A1:A10,&10) I think i want it to look like "=randsfromrange(A1:A" & I & "," & I &")"
This obviously isn't working.
Any ideas?
I was hoping this is an easy fix, but if you need more info please let me know.
Thanks.
Bookmarks