How can I use the active cell address as a value

M

mohavv

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
 
J

JE McGimpsey

One way:

To fill row 2:100:

Cells(2, ActiveCell.Column).Resize(99, 1).FormulaR1C1 = _
"=R[-1]C[]+1"
 
B

Barb Reinhardt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

use current cell address as beginning of macro 2
to change the macros as per active cell and range 2
Excel VBA 1
Active Cell? 2
Pasting cell contents into a macro 1
Set a variable to the active cell 1
Event when a specific cell changes 1
How do I get row and column of active cell to highlight? 2

Top