| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pointing directly to a cell in a range
C-Accounts is the value contained in the cell. I thought that it might be possible to treat a range as a associate array and use the cell values to access certain cells in the range. The reason I want to select the cell containing 'C-ACCOUNTS' is because I want to get a value in a cell that is 15 rows below. The range is in workbook wkBk, and the Worksheets is "All Data Unnarr". i'm not even sure this is possible, I can always use a loop, but I thought this way would be tidier. Cheers, Tom -- Tomski ------------------------------------------------------------------------ Tomski's Profile: http://www.excelforum.com/member.php...o&userid=26824 View this thread: http://www.excelforum.com/showthread...hreadid=500720 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMIF - pointing to another cell for criteria | Excel Discussion (Misc queries) | |||
| Pointing on a cell shows me a list . . .how to do that ? | Excel Discussion (Misc queries) | |||
| trouble shoot pointing to a cell | Excel Worksheet Functions | |||
| Not unhiding rows when pointing to cell to complete formula entry | Excel Programming | |||
| VBA to copy to empty cell directly below a cell when analogous cells in different column have same value as each other? | Excel Programming | |||
![Tomski[_10_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
