Re: $$Excel-Macros$$ Relative references

Thanks friends On Mon, Feb 8, 2010 at 7:00 PM, Dave Bonallack wrote: > 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: M

RE: $$Excel-Macros$$ Relative references

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 To: excel-mac

Re: $$Excel-Macros$$ Relative references

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

Re: $$Excel-Macros$$ Relative references

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