Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using variable addresses in vba
Hi
Here is a problem that has kept me scratching my head for some time. I have two dynamically changing columns of data in columns A and B. For each column, the rows are incremented using variable MEASUREMENT for A and B in vba. There are 20 machines whose numbers appear in A and their corresponding measurements appear in B. The columns contain many measurements for each machine. I would like to accomplish the following example in vba using the variable MEASUREMENT. Example: For machine # 12 in column A, (range = A1:A(MEASUREMENT)), find the MAX of its corresponding measurements in column B (range = B1:B(MEASUREMENT)) and save it in cell C1. I would like to accomplish this without using volatile functions like OFFSET and COUNT. Any help is appreciated as I am running out of ideas. Thanks JP Using Windows XP, Excel 2003 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Runtime Error '91' Object variable or With block variable not set | Excel Discussion (Misc queries) | |||
Variable Addresses in Links | Excel Worksheet Functions | |||
Variable range addresses for use in array functions | Excel Discussion (Misc queries) | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Cells.Find error Object variable or With block variable not set | Excel Programming |