ExcelBanter - Excel Macro

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Macro (https://www.excelbanter.com/excel-discussion-misc-queries/195834-excel-macro.html)

RCB

Excel Macro

Can anyone tell me the macro language to instruct the cursor to move over x
number of cells?
--
RCB

FSt1

Excel Macro

hi
activecell.offset(0,x).select

the offset number are offset(row,column)
row - negative numbers = left
positive numbers = right
column = negative numbers = up
positive numbers = down

regards
FSt1

"RCB" wrote:

Can anyone tell me the macro language to instruct the cursor to move over x
number of cells?
--
RCB

RCB

Excel Macro

Thank you!
--
RCB

"FSt1" wrote:

hi
activecell.offset(0,x).select

the offset number are offset(row,column)
row - negative numbers = left
positive numbers = right
column = negative numbers = up
positive numbers = down

regards
FSt1

"RCB" wrote:

Can anyone tell me the macro language to instruct the cursor to move over x
number of cells?
--
RCB

All times are GMT +1. The time now is 11:02 PM.