I've written the code below, but am getting a "subscript out of range" error at the line in bold. My array is working (I checked it earlier by populating it into a range to test), so I'm wondering if there's some syntax issue with that bolded part.
What I'm trying to do there is multiply every item in column L by element 1 in my array, and populate that result in Column M.
Array Sample.xlsx
Please Login or Register to view this content.
I am getting a type mismatch, not subscript out of range. You are trying to multiply a scalar value (the Percent) times an array and that doesn't make sense. Maybe you want to multiply each element of the array times Percent.
Please Login or Register to view this content.
Hmm...Percent actually is the array. I used a user defined type and Percent refers to the second column on the DMA tab. Basically I want to multiply every cell in that range by a particular percent within the array.
Just got a chance to test out the correction...that works perfectly. Exactly what I was trying to do. Thanks!
Actually, here's a follow-up question: Is there anyway to do this without using a loop? The real version of this data is very lengthy (tens of thousands of rows)...
perhaps
Please Login or Register to view this content.
Josie
if at first you don't succeed try doing it the way your wife told you to
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks