| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
paste in next availible column?
set lastcol = Worksheets("Other").Cells(3,"IV").End(xltoLeft)
selection.Copy Destination:=LastCol.Offset(0,1) -- Regards, Tom Ogilvy "cwatson" wrote in message ... i have multiple selections in three column blocks that need to be pasted in the next free column of another sheet or the next free cell horizantally. needs to be in VBA code ty all -- cwatson ------------------------------------------------------------------------ cwatson's Profile: http://www.excelforum.com/member.php...o&userid=24608 View this thread: http://www.excelforum.com/showthread...hreadid=382480 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A way to increase the number of columns availible in Excel? | Excel Discussion (Misc queries) | |||
| Is there AccessLinks add-in program availible in 2003? | New Users to Excel | |||
| In excel pointers should be availible | Excel Worksheet Functions | |||
| Is it possible to increase Excel's availible memory? | Excel Programming | |||
| Is it possible to increase Excel's availible memory? | Excel Programming | |||
Hybrid Mode
