Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving one cell with macros
Using macros I want to move down one cell from where ever position I am..
have tried recording a macro but it always give the the specific cell I moved... I need it to move one cell down. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving one cell with macros
Try this.
Sub MoveIt() ActiveCell.Offset(1, 0).Select End Sub HTH Regards, Howard "Alberto Ast" wrote in message ... Using macros I want to move down one cell from where ever position I am.. have tried recording a macro but it always give the the specific cell I moved... I need it to move one cell down. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving one cell with macros
Try
Activecell.Offset(1).Select If this post helps click Yes --------------- Jacob Skaria "Alberto Ast" wrote: Using macros I want to move down one cell from where ever position I am.. have tried recording a macro but it always give the the specific cell I moved... I need it to move one cell down. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving one cell with macros
This is excellent.. I knew it had to be something simple but if you do not
know it always will be complicated... here is near midnight so I though I was going to get an answer until tomorrow... this is great thanks. "Jacob Skaria" wrote: Try Activecell.Offset(1).Select If this post helps click Yes --------------- Jacob Skaria "Alberto Ast" wrote: Using macros I want to move down one cell from where ever position I am.. have tried recording a macro but it always give the the specific cell I moved... I need it to move one cell down. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Moving one cell with macros
Thanks this works great.... I was not expecting an answer until tomorrow...
it is midnight over here. Regards "L. Howard Kittle" wrote: Try this. Sub MoveIt() ActiveCell.Offset(1, 0).Select End Sub HTH Regards, Howard "Alberto Ast" wrote in message ... Using macros I want to move down one cell from where ever position I am.. have tried recording a macro but it always give the the specific cell I moved... I need it to move one cell down. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving / sharing Macros between workstations | Excel Worksheet Functions | |||
Moving Macros | Excel Worksheet Functions | |||
Moving Macros from one computer to another Excel 2000 | Excel Discussion (Misc queries) | |||
Force user to enter data in cell before moving to next cell | New Users to Excel | |||
Moving Macros | Excel Discussion (Misc queries) |