| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range(sheet2) = Range(sheet1)
Instead of this which does the job but leaves the range on sheet 2 selected: Sheets("Sheet1").Range("A2:F2").Copy Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp)(2).PasteSpecial Paste:=xlPasteValues I'm trying to do the code line whe (Sheet2)Range = (sheet1)Range and does the offset & paste special also Thanks. Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple? View named range from sheet1 on sheet2 | Excel Worksheet Functions | |||
| Copy range from Sheet1 into empty range in Sheet2 | Excel Programming | |||
| Populate growing range of cells from Sheet1 to Sheet2 | New Users to Excel | |||
| copy cell B19:J19 Range datas from sheet1, and to past in sheet2 | Excel Programming | |||
| A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
Threaded Mode
