I used ADDRESS function to create a column of cell addresses

Now how to I use them to assign a literal "CASH OUT" to the cells identified in that column?

I know this is an easy one for somebody.

Years ago, I could do it in LOTUS 1-2-3. Gotten dumber, and do not know VBA.

For example, if you have "$C$20" as the address in cell A1, and you type =INDIRECT(A1) into B1, the value located in C20 will appear in B1.


Ok, I got that far. I have no problem in accessing data existing in C20, but what I want to do is insert a new value into c20, and for every other of the addresses in my column.

How do I do that?

Originally Posted by LEberhart

For example, if you have "$C$20" as the address in cell A1, and you type =INDIRECT(A1) into B1, the value located in C20 will appear in B1.


Ok, I got that far. I have no problem in accessing data existing in C20, but what I want to do is insert a new value into c20, and for every other of the addresses in my column.

How do I do that?

you need to use VBA
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Address <> "$b$1" Then
Target.Value = [b1]
End If
End Sub