| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba offset program
Hi. I have another question. I am trying to post this: OFFSET($A$4,MATCH
(C21,$A$5:$A$17,0),MATCH(D21,$B$4:$M$4,0)) into a vba program but can't get it to work. I understand that the $$ are not recognized in vba and also, how would I go about putting this equation into a sub procedure? I tried calling it price = offset(....... Also, this is a set range that will not move. How can the program be structured to where $a$4 will always be the range or array's starting point? I have stock symbols in a row with dates down the left column. Stock prices fill the range. thansk. chris -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200707/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
| Compare Cell Values, Offset(-1,0), Offset(-1,-1), and xlFillDefaul | Excel Worksheet Functions | |||
| Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
| Problem with Range.Cells.Offset and Range.Cells( row + offset, column) | Excel Programming | |||
| merging excel program with tdc finance program | Excel Programming | |||
Threaded Mode
