| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refernce header text in code
vb novice
in my code currently, i am using (1,3) format for cell ref in things like Offset, etc. What i would like to do is have the column not be based on a number, but the header text in row 5. in other word when b8 is active cell then the offset would be (0, and whatever column contains "Invoice #" in header row 5. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop through code and refernce text file for info | Excel Discussion (Misc queries) | |||
| Using IF to refernce another cell | Excel Programming | |||
| Omit header from first page without embedding header in code | Excel Worksheet Functions | |||
| Circular Refernce | Excel Discussion (Misc queries) | |||
| Range refernce question... | Excel Programming | |||
Threaded Mode
