About Us

Prashant Garg[_2_]

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.....

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help defining dynamic range	joecrabtree	Charts and Charting in Excel	0	December 6th 06 03:33 PM
Defining a name that represent identical ranges in every sheet	Bernard	Excel Discussion (Misc queries)	1	August 31st 06 02:18 PM
Defining Ranges	Steve	Excel Worksheet Functions	5	May 28th 05 07:41 AM
Defining ranges in VB code	Rachael Moody	Excel Programming	5	January 27th 04 02:21 PM
Defining Ranges	Greg Ghavalas	Excel Programming	2	July 9th 03 10:10 PM

Menu

About Us