| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range problems
i am gettin an error evertime the run gets to the range("name").selec
can any one help me identify the problem Private Sub cmdVan1_Click() Sheets("Van 1 ").Select Range("B2:B8").Select Selection.Copy Sheets("Work Order").Select Range("B2:B8").Select ActiveSheet.Paste Sheets("Van 1 ").Select Range("C10").Select Application.CutCopyMode = False Selection.Copy Sheets("Work Order").Select Range("B12").Select ActiveSheet.Paste Sheets("Van 1 ").Select Range("E10").Select Application.CutCopyMode = False Selection.Copy Sheets("Work Order").Select Range("C12").Select ActiveSheet.Paste Sheets("Service schedule").Select Range("B2:C2").Select Application.CutCopyMode = False Selection.Copy Sheets("Work Order").Select Range("B11:C11").Select ActiveSheet.Paste Application.CutCopyMode = False ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True Range("B2:B8").Selec -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problems editing data range | Excel Discussion (Misc queries) | |||
| Range name problems | Excel Discussion (Misc queries) | |||
| Named range causing really weird problems - HELP | Excel Discussion (Misc queries) | |||
| Excel Page Range Printing Problems | Excel Discussion (Misc queries) | |||
| Variables and range problems | Excel Programming | |||
Threaded Mode
