| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to Cell
"Ronbo" wrote in message ... That is a cool function, but it can only ref one column. Second, is it possible to make it dynamic so that it changes with the list size? If we assume the list is in A1:An, use this formula with the DV list =OFFSET($A$1,,,COUNTA($A:$A)) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'IF' Macro to insert cell contents to alternate cell if cell not e | Excel Worksheet Functions | |||
| using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
| macro to run a separate macro dependent on value in cell | Excel Programming | |||
| Please help! Macro to change cell contents based on cell to the left | Excel Programming | |||
| Question: Cell formula or macro to write result of one cell to another cell | Excel Programming | |||
![Bob Phillips[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
