| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
select method of range class failing ?
there are 2 control buttons, the next lines of code will delete them (but
that code could be moved they are not wanted on this sheet, but are on the parent tht this was copied from) "Chip Pearson" wrote in message ... Your code works fine for me. Do you have controls or charts on the sheet? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "mark kubicki" wrote in message ... i am creating this code by recording a macro -so obviously, it run... but when i put it into code , it crashes: "select method of range class failed" on the last line? Sheets("KTA Issue").Select Sheets("KTA Issue").Copy Befo=Sheets(1) Sheets("KTA Issue (2)").Select Sheets("KTA Issue (2)").Name = "1st Issue" Sheets("1st Issue").Select Range("A6:F8").Select suggestions? thanks in advance, -mark |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select method of Range class failed - but why??? | Excel Programming | |||
| select method of range class failed | Excel Programming | |||
| select method of range class failed | Excel Programming | |||
| select method of range class failed | Excel Programming | |||
| Select method of Range class failure | Excel Programming | |||
Threaded Mode
