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