| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting to the bottom of it
Hi tbmarlie,
Sorry I didn't get back before, just got in: This is all one line which should explain the syntax error: ActiveSheet.Paste _ Destination:=Worksheets("Sheet1").Range(LastCell.O ffset(1, 1), _ LastCell.Offset(1, 6)) Having said that I saw the code Dave Peterson posted; much more elegant than mine and shorter to boot! I'd use that especially as he explained it well. Good Luck. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 5 vs Bottom 5 | Excel Discussion (Misc queries) | |||
| Top 10% and Bottom 10% | Excel Worksheet Functions | |||
| dislike jump bottom of column by double-clicking the bottom of cel | Excel Discussion (Misc queries) | |||
| Top to bottom | Excel Discussion (Misc queries) | |||
| how to paste data from top to bottom to bottom to top | Excel Discussion (Misc queries) | |||
Threaded Mode
