changing active cells
Posted by nope on February 17, 2001 3:07 PM
I'm not getting this.
I have three columns with values in the first two. I'd like to write a macro that goes down the third column and pastes in a formula for as long as the first two have values.
I've figured out a good part of this - I think - but am having trouble with selecting the right cells.
Here it is so far:
Dim MyCell As Range
For Each MyCell In Range("P6:P65536")
If MyCell >= 0 Then
ActiveCell.FormulaR1C1 = "=RC[-1]*RC"
Suggestions are welcome, but I'd also like to really grasp the concepts in case I need something like this in the future. What/where is a good reference on how to make selections in Excel?