---
> Date: Mon, 8 Feb 2010 05:27:37 -0800
> Subject: $$Excel-Macros$$ Relative references
> From: shivyn...@gmail.com
>
> To: excel-macros@googlegroups.com
>
> Hi friends
>
> Please tell me the this code meaning
>
>
>
> Sub SelectRelativ
Hi,
The .Range("A1") part of the code does nothing.
The line can be rewritten:
ActiveCell.Offset(1, 0).Select
which moves the selection down one cell.
Regards - Dave.
Date: Mon, 8 Feb 2010 05:27:37 -0800
Subject: $$Excel-Macros$$ Relative references
From: shivyn...@gmail.com
Hi Shiv,
ActiveCell.Offset(1, 0).Range("A1").Select , moves one cell down to the
current cell. Complete syntax is ActiveCell.Offset(rowno,
columnno).Range("A1").Select , for example if u want to move one column from
active cell then u can use
ActiveCell.Offset(0, 1).Range("A1").Select.
I hope thi
hi shiv,
it does nothing apart from moving one cell down from A1
On Mon, Feb 8, 2010 at 6:57 PM, Shiv Goel wrote:
> Hi friends
>
> Please tell me the this code meaning
>
>
>
> Sub SelectRelative()
> ActiveCell.Offset(1, 0).Range("A1").Select
> End Sub
>
>
> What is the meaning of this color
Hi friends
Please tell me the this code meaning
Sub SelectRelative()
ActiveCell.Offset(1, 0).Range("A1").Select
End Sub
What is the meaning of this color line
--
--
Some important links for excel users:
1. F
