| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Adding new row(s) to end of worksheet
What is the code or is there a way to make a macro that
will go the first empty row and insert a new row (similar to a fill) with the next data in sequence? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Adding new row(s) to end of worksheet
Mike
cRows = Cells(Rows.Count,"A").End(xlUp).Row Cells(crows+1,"A")=123 Cells(cRows+1,"B")="alpha" etc. This locks down column A for the last row, and then populates columns A, B, etc of the next row. That should give you the idea. -- HTH Bob Phillips "Mike Fenton" wrote in message ... What is the code or is there a way to make a macro that will go the first empty row and insert a new row (similar to a fill) with the next data in sequence? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with adding a worksheet | Setting up and Configuration of Excel | |||
| adding several worksheet cells onto a main worksheet | Excel Worksheet Functions | |||
| Adding Worksheet | Excel Worksheet Functions | |||
| Adding worksheet tab names to the first worksheet | Excel Discussion (Misc queries) | |||
| list worksheet macros/VBA without adding worksheet | Excel Discussion (Misc queries) | |||
Hybrid Mode
