| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer to Ranges using Cells notation
Hi,
I am trying to pass through a worksheet using VBA with a nested For loop and would like to refer to the cells that I pass through using the Cells(row, col) notation. Is there a way to refer to a range of cells (e.g. A1:A100) using the Cells(row, col) notation instead of having to use the Range notation? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering formula using cells notation | Excel Worksheet Functions | |||
| how to find cells that refer to data in other cells in excel | Excel Discussion (Misc queries) | |||
| Scientific notation in text cells | Excel Discussion (Misc queries) | |||
| Refer to Worksheet Ranges in Code | Excel Programming | |||
| refer to a cells value in a macro | Excel Programming | |||
Threaded Mode
