| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
what VBA command is used to go to the next blank row in Excel?
I'm writing a macro to cut and paste data to the next blank row in an Excel
file. Any ideas? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what VBA command is used to go to the next blank row in Excel?
Hi Bobby
See how I do it here http://www.rondebruin.nl/copy1.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Bobby J" <Bobby wrote in message ... I'm writing a macro to cut and paste data to the next blank row in an Excel file. Any ideas? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what VBA command is used to go to the next blank row in Excel?
Depends of what you want. No difference IF no blanks
nextblankrow=cells(activecell.row,"a").end(xldown) .row+1 lastblankrow=cells(rows.count,"a").end(xlup).row+1 -- Don Guillett Microsoft MVP Excel SalesAid Software "Bobby J" <Bobby wrote in message ... I'm writing a macro to cut and paste data to the next blank row in an Excel file. Any ideas? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what VBA command is used to go to the next blank row in Excel?
Check out:
http://www.mrexcel.com/articles/copy...-blank-row.php "Bobby J" wrote: I'm writing a macro to cut and paste data to the next blank row in an Excel file. Any ideas? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
what VBA command is used to go to the next blank row in Excel?
On May 27, 8:52*pm, Rugby Stud
wrote: Check out:http://www.mrexcel.com/articles/copy...-blank-row.php "Bobby J" wrote: I'm writing a macro to cut and paste data to the next blank row in an Excel file. *Any ideas?- Hide quoted text - - Show quoted text - Use this Range("A1").end(xldown).offset(1,0).select Activesheet.paste Regards Rakesh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stopping IF command from entering zero or 1 for blank cells | Excel Worksheet Functions | |||
| 'Insert' 'Object' command: I have 11 blank rows of objects at top | Excel Discussion (Misc queries) | |||
| Excel to load COMMAND and type a Run Command? | Excel Programming | |||
| Keyboard Command to go to next blank cell | Excel Discussion (Misc queries) | |||
| Deletion of cells by next blank cell command?? | Excel Programming | |||
Hybrid Mode
