Hi fellow VBAers,
Basically, in Sheet "USB_WLs" I have 3 columns similar to below:
A B C
1 1 3
1 2 5
1 3 16
1 4 1
2 1 3
2 2 8
3 1 9
. . .
. . .
I require the minima of column C within each class or group defined by equal values in column A - i.e., min(class1) = 1, min(class2) = 3.
Previously, I have written a VBA which defines the range of A(1), A(2) etc., in order to create new charts pertaining to the times series of C(i) (hence, Col B is time). The code is given below. Note that this code is correct.
I thought that calculating Min/Max/Ave of each of these groups in A would involve a simple alteration (given arguably the most difficult part is done - i.e., defining the variable ranges). I was wrong. This is what I have so far. I'm getting the error 91: Object variable or With block variable not set.Please Login or Register to view this content.
From what I've seen on this forum, when you require the use of xlApps you need to specify objects etc (e.g., Dim xlApp As Object). I'm not sure if that is necessary, but I have done it for all variables.Please Login or Register to view this content.
Any assistance here would be appreciated hugely!
Cheers,
Matt
Bookmarks