VBA................
Activecell.Offset(0,25).Select to go to the cell 25 columns to right
Range("F4").Offset(0,25).Select to go to the cell
Range("F4").Value = Range("F4").Offset(0, 25).Value to return the value
Formula..................
=OFFSET(F4,0,25) will return the value of AE4
=OFFSET(F4,0,22) will return the value of AB4
Gord Dibben Excel MVP
On Tue, 22 Nov 2005 11:40:48 +0800, "raymond chiu"
wrote:
Dear All,
I am using VB to manipulate the excel.
How can I get the cell(e.g. "AB4", column AB and Row4) if I want to shift
25 columns to right from "F4" cell.
What the formula should be in VB or excel?
Thanks,