Thread: Deleting All Sheets Other than specified from a workbook
View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Deleting All Sheets Other than specified from a workbook
Hi
you have to activate the workbook and worksheet first.
Try
Workbooks("Excel Matrix Database - A3 Copy Of Gates + Full
Matrix.xls").Activate
Worksheets("GateA").Activate
Range("GateA").select

Frank

Excellent thankyou..

One small question

why does this not work?

Workbooks("Excel Matrix Database - A3 Copy Of Gates + Full
Matrix.xls").Worksheets("GateA").Select

Am I missing something?


NIc


---
Message posted from http://www.ExcelForum.com/


Reply With QuoteReply With Quote