ExcelBanter - shift right 5 columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - shift right 5 columns (https://www.excelbanter.com/excel-worksheet-functions/56676-shift-right-5-columns.html)

shift right 5 columns

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,

shift right 5 columns

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,