Thread: sheets.select
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kurt kurt is offline
external usenet poster
 
Posts: 23
Default sheets.select

Hi

I Have a funny thing
Wen I run a VBA macro with this code


Debug.Print Me.Name (
Debug the file name correct)
Debug.Print ActiveSheet.Name ( Debug
the actual sheetname correct)
Workbooks("filename.xls").Activate
Sheets("Sheet name").Select



But it dont select the new sheet (sheet name) ??
It doesent either work with Windows("filename.xls").Activate

I am using windows 2000 and excell 2003

Anyone have an Idea??


regards

Kurt