| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
| Clearing information in certain columns | Excel Discussion (Misc queries) | |||
| Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Linear Mode
