Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Moving
I copied from the Internet data into one column. I'd like to automatically
move one cell with data one column across (to the right) and two lines up so it sits next to another line with data. To do this I would have to write a macro, selecting and shifting 2oo times. Is there a way in a macro to move down 11 lines and right 1 column rather then every time selecting a specific cell and move it? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Moving
activecell.copy activecell.offset(11,1)
Will copy the active cell down 11 rows and one column to the right to actually move use CUT instead of COPY But, tell us what you are trying to do. There may be a better way. -- Don Guillett Microsoft MVP Excel SalesAid Software "Felix" wrote in message ... I copied from the Internet data into one column. I'd like to automatically move one cell with data one column across (to the right) and two lines up so it sits next to another line with data. To do this I would have to write a macro, selecting and shifting 2oo times. Is there a way in a macro to move down 11 lines and right 1 column rather then every time selecting a specific cell and move it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
Automatic moving cell Info | Excel Worksheet Functions | |||
Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
Automatic Moving to the Next Cell | Charts and Charting in Excel | |||
moving automatic vertical pagebreak | Excel Programming |