| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I dentifying cell and ranges using n as in For n =1 to 600
I am trying to run a VBA For/ Next loop that contains an If function e.g. For n = 1 to 600, If cell C1 ="XYZ" then Range("A1:J1") Select Selection delete ,End If next n. I want to be able to identify th Cell and the Range using n. i.e. I want to identify the cell as Cn an the Range as "An:Jn" . How do I do that -- knowtrum ----------------------------------------------------------------------- knowtrump's Profile: http://www.excelforum.com/member.php...fo&userid=1966 View this thread: http://www.excelforum.com/showthread.php?threadid=50266 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grouping cell ranges | Excel Discussion (Misc queries) | |||
| How to specify cell ranges dynamically? | Excel Worksheet Functions | |||
| Cell ranges | Excel Discussion (Misc queries) | |||
| Named Cell Ranges | Excel Discussion (Misc queries) | |||
| Specifying ranges relative to a cell | Excel Programming | |||
Threaded Mode
