subtracting column from column

[Guest]

I am trying to get the value from one cell while in another. If I am at "C6"
(I have this in a variable) I need to know how to get the value from "A6".
How do I do this?

--
Regards

Rick
XP Pro
Office 2007

 

[Guest]

The cell I get information from will always be different, reading cell.value
from column "A" dependant on cell.address (row) of any other cell.

--
Regards

Rick
XP Pro
Office 2007

 

[Don Guillett]

msgbox cells(activecell.row,1)

 

[Guest]

there's a couple of ways. If you want C6 to equal A6 value then:
Cells(6, 3) = Cells(6, 1) Or Cells(6, 3) = Cells(6, 3).Offset(0, -2)
If you just want to capture the value then use a variable:
myVar = Cells(6, 1).Value

Those are all VB code. If you are in Excel and using formulas then
in Cell C6 you put: = A6

You can use the Offset method to move around the sheet while using a
variable value like: For i = 1 To Rows.Count
For x = 1 To Columns.Count
Cells(6, 3) = Cells(i, x)
Next x
Next i


Since the answer is that simple, I must not be answering your real question,
Right?

 

[Don Guillett]

or

cells(activecell.row,activecell.column)=cells(activecell.row,1)