Hello I would like to create own function in VBA for range.
I've got this:
But I cant make it works with cells, offset or anything I know, so I think that new fuction will be better for this case. Any helps? Thak you for your time.
Please Login or Register to view this content.
Thanks for the mod.
Last edited by protonLeah; 08-09-2014 at 03:37 PM.
Ben Van Johnson
What do you want to do with your UDF??
- Battle without fear gives no glory - Just try
Process 3 cells in each row and sum the output. (Ai/Bi)-Ci = x
Perhaps
Please Login or Register to view this content.
Please Login or Register to view this content.Please Login or Register to view this content.
There is no problem with 0 value (I tought that loop starts from "For") but its returning some errors I cant type W = W + ((T / A) - B)
r-t error: 13
PCI: this is function for one roow, but I need SUM from each
First you say:
Range("D30").Value = 0
"... I tought that loop starts from "For ... "
It does but inside the loop you say:
W = Range("D30").Value
D30 = 0, therefore W = 0 (each time through the loop)
Next, you calculate W. But that line (in the loop): W = Range("D30").Value wipes out that calculation at the next iteration of the loop.
The last time through the original loop W is calculated but not written do D30, it's just lost.
The code I gave you accumulates the twenty calculations and writes them to D30 (tested). The calculation equation did not give me any error.
Thank you I had problems with blanks rows v1 code is:
Thank you for your help.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks