Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a macro seek the botom of a list?
I'm trying to copy data from a file and paste it at the bottom of other data
using a macro. manually, i would copy the selection toggle to my other open sheet, press CTRL <down to jump to the bottom of the data and then paste. when i try this in a macro it always jumps to a specific cell rather than a relitive one. anyone know how to rewrite the VB code to make this relitive? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I make a macro seek the botom of a list?
Hi,
In a macro this would find the last used cell in colum A of the active sheet LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row So we add 1 to that to get the empty cell below LastRow = Cells(Cells.Rows.Count, "A").End(xlUp).Row+1 And to turn that into a range to paste into we could use Range("A" & Lastrow).pastespecial or whatever type of paste you want to do -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "chads_vstream" wrote: I'm trying to copy data from a file and paste it at the bottom of other data using a macro. manually, i would copy the selection toggle to my other open sheet, press CTRL <down to jump to the bottom of the data and then paste. when i try this in a macro it always jumps to a specific cell rather than a relitive one. anyone know how to rewrite the VB code to make this relitive? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how I will gat count rows number and r botom coner | Excel Discussion (Misc queries) | |||
Macro to make a cum list | Excel Worksheet Functions | |||
the right botom does not work in excel 2003 | Excel Discussion (Misc queries) | |||
Goal Seek - Why make the PV negative? | Excel Discussion (Misc queries) |