Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move down 1 cell after going to the end of my data.
Please can someone let me know what I should enter to move down to the next
cell in my macro,instead of it moving to a specific cell. I recorded the following, but instead of going to cell A15 i want to go down to the next cell. Many Thanks in advance. Selection.End(xlDown).Select Range("A15").Select |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move down 1 cell after going to the end of my data.
On Jan 4, 11:40 am, Pendelfin wrote: Please can someone let me know what I should enter to move down to the next cell in my macro,instead of it moving to a specific cell. I recorded the following, but instead of going to cell A15 i want to go down to the next cell. Many Thanks in advance. Selection.End(xlDown).Select Range("A15").Select Try Selection.Offset(1,0).Select or more tersely Selection.End(xlDown).Offset(1,0).Select HTH, Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move down 1 cell after going to the end of my data.
Selection.End(xlDown)(2, 1).Select
An Offset feature (2=nextrow,1=same column). (1, 1) would be no offset. Mike F "Pendelfin" wrote in message ... Please can someone let me know what I should enter to move down to the next cell in my macro,instead of it moving to a specific cell. I recorded the following, but instead of going to cell A15 i want to go down to the next cell. Many Thanks in advance. Selection.End(xlDown).Select Range("A15").Select |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move down 1 cell after going to the end of my data.
If you are saying you want to copy the formula from B8 then
Selection.Offset(1,0).Select activecell.offset(-1,0).copy activecell possibly. -- Regards, Tom Ogilvy "KLEM" wrote in message ... Hi Mike, Sorry to 'piggy-back' on this thread, but you've answered part of my question which is great. Need to pick your brains....my other question is: E.g Worksheet 2's cell B8 has a formula which copies the data from another cell from worksheet 1. I use Selection.Offset(1,0).Select in W/sheet 2 to move down 1 cell to B9, however I still want to retain the formula from B8 but not the same info. Hope this makes sense...any help will be greatly appreciated. -- KLEM "Mike Woodhouse" wrote: On Jan 4, 11:40 am, Pendelfin wrote: Please can someone let me know what I should enter to move down to the next cell in my macro,instead of it moving to a specific cell. I recorded the following, but instead of going to cell A15 i want to go down to the next cell. Many Thanks in advance. Selection.End(xlDown).Select Range("A15").Select Try Selection.Offset(1,0).Select or more tersely Selection.End(xlDown).Offset(1,0).Select HTH, Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Move cell data to another worksheet cell automatically. | New Users to Excel | |||
How do I move certain Cell data from one worksheet to another? | Excel Worksheet Functions | |||
Need help with macro to move cell data | Excel Programming | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) | |||
How do I move data from one cell and add to another? | Excel Worksheet Functions |