| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I use the active cell address as a value
How can I use the active cell address as a value as a start for a
macro. I want to fill a certain range in one column with a formula. This should be the column in which the active cell is positioned. Any idea? Cheers, Harold |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I use the active cell address as a value
One way:
To fill row 2:100: Cells(2, ActiveCell.Column).Resize(99, 1).FormulaR1C1 = _ "=R[-1]C[]+1" In article , mohavv wrote: How can I use the active cell address as a value as a start for a macro. I want to fill a certain range in one column with a formula. This should be the column in which the active cell is positioned. Any idea? Cheers, Harold |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I use the active cell address as a value
You're going to need to provide more information on what you want. In a
macro, you can use the value ActiveCell.Address ActiveCell.Value = "your formula" Not sure what you want to do so can't give any more detail. -- HTH, Barb Reinhardt "mohavv" wrote: How can I use the active cell address as a value as a start for a macro. I want to fill a certain range in one column with a formula. This should be the column in which the active cell is positioned. Any idea? Cheers, Harold |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| active cell address with worksheet function | Excel Worksheet Functions | |||
| referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
| Get Address of Active Cell | Excel Discussion (Misc queries) | |||
| Find address of active cell | Excel Worksheet Functions | |||
| If Statment - Active Cell Column Address | Excel Discussion (Misc queries) | |||
Linear Mode
