Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining Dynamic Ranges in Macro
I have a data worksheet in which I have to update record using a different sheet (form for data entry). I recorded a Macro where by records were copied from the form sheet , and copied after the last record in data sheet. ( Say the last record was in row 10, so the data has to be updated in row 11) But when the macro is recorded the number for the last row which was updated while recording gets fixed (in this case row 11) , therefore when the macro is rerun everytime row 11 is updated. I require that this number should be generated after looking at data sheet and identifying the last row record. If anyone can help..... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Defining Dynamic Ranges in Macro
Thanks Jim ,
Its Working Now. Regards "Jim Rech" wrote: Typically we use the equivalent of the keyboard Ctrl-Arrow to find the next empty cell: Range("A1").End(xlDown).Offset(1).Select This assumes at least A1 and A2 have entries. -- Jim Rech Excel MVP "Prashant Garg" <Prashant wrote in message ... | | I have a data worksheet in which I have to update record using a different | sheet (form for data entry). | | I recorded a Macro where by records were copied from the form sheet , and | copied after the last record in data sheet. ( Say the last record was in row | 10, so the data has to be updated in row 11) | | But when the macro is recorded the number for the last row which was updated | while recording gets fixed (in this case row 11) , therefore when the macro | is rerun everytime row 11 is updated. | | I require that this number should be generated after looking at data sheet | and identifying the last row record. | | If anyone can help..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
help defining dynamic range | Charts and Charting in Excel | |||
Defining a name that represent identical ranges in every sheet | Excel Discussion (Misc queries) | |||
Defining Ranges | Excel Worksheet Functions | |||
Defining ranges in VB code | Excel Programming | |||
Defining Ranges | Excel Programming |