Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro selecting wrong cell range
I track orders in excell, when new orders are entered at the end of
the day I open the file they are entered into copy & paste at the bottom of mine. I recorded a macro to do this for me but it does not go to the end of the list to paste the new orders it goes back to the same cell that was selected when the macro was recorded. (I press Ctrl down to go to the end of the list, which was row #7325 when I recorded the macro & that is the cell it goes back to) How do I have the Macro go to the end regardless how long the list is? I have the same problem selecting the cell range to copy (again Shift+Ctrl+down) to hilight all of the list but when I edit the macro it is calling for a specific cell range so if the next day has more orders, some of the ones at the bottom will not get coppied. Thank you for your help |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro selecting wrong cell range
Assuming that you are looking at column A
Cells(Rows.Count,"A").End(xlUp).Offset(1,0).Select -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Josh" wrote in message om... I track orders in excell, when new orders are entered at the end of the day I open the file they are entered into copy & paste at the bottom of mine. I recorded a macro to do this for me but it does not go to the end of the list to paste the new orders it goes back to the same cell that was selected when the macro was recorded. (I press Ctrl down to go to the end of the list, which was row #7325 when I recorded the macro & that is the cell it goes back to) How do I have the Macro go to the end regardless how long the list is? I have the same problem selecting the cell range to copy (again Shift+Ctrl+down) to hilight all of the list but when I edit the macro it is calling for a specific cell range so if the next day has more orders, some of the ones at the bottom will not get coppied. Thank you for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for Selecting Cells within a Range | Excel Worksheet Functions | |||
Selecting a range of cells in a macro | Excel Discussion (Misc queries) | |||
Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
Highlight Range - wrong macro, please edit. | Excel Worksheet Functions | |||
Selecting Variable Row Range w/Macro | Excel Programming |