| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select a series of cells
I am looking for a one time use macro which will select and then deselect
each cell in the range G7:P300. I need this to trigger a worksheet change macro in each of the cells. I can do this manually by selecting the cell then clicking in the formula bar then selecting the next cell. But that is close to 3000 cells and would be very time consuming. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select a series of cells
Dim c as Range
for each c in Range("G7:P300") c.select next c -- Regards, Nigel "Patrick C. Simonds" wrote in message ... I am looking for a one time use macro which will select and then deselect each cell in the range G7:P300. I need this to trigger a worksheet change macro in each of the cells. I can do this manually by selecting the cell then clicking in the formula bar then selecting the next cell. But that is close to 3000 cells and would be very time consuming. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Up down arrow keys do not select cells if select locked cells unch | Excel Discussion (Misc queries) | |||
| How to select series in chart? | Excel Discussion (Misc queries) | |||
| How to select series in chart? | Charts and Charting in Excel | |||
| Chart select, yet changing set of series | Charts and Charting in Excel | |||
| Using arrays to select a series of cells | Excel Discussion (Misc queries) | |||
Linear Mode
