Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding the next empty column
i am new to vba and am keen to learn from others with more experience.
this came from this ms discussion groups. it copies a range in col 1 of sheet 1 to col 1 of sheet2 Sub test() With Sheets("Sheet1") .Range("A1:A" & .Range( _ "A" & .Rows.Count).End(xlUp).Row).Copy Sheets("Sheet2").Range("A1") End With End Sub i am happy to use this but i would like it to be a bit more sophisticated in choosing where in sheet 2 it pastes. i would like the destination in sheet 2 to be "..in the colum immediately to the right of the last colum that has data in it". could someone pls start me off with a bit of code pls. thanking you in advance. -- Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Finding First Empty Cell in a Column | Excel Discussion (Misc queries) | |||
Finding Next Empty Cell in Column | Excel Programming | |||
Finding the first empty cell in a column | Excel Programming | |||
Finding last non-empty column in row... | Excel Programming |