View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] paul.robinson@it-tallaght.ie is offline
external usenet poster
 
Posts: 789
Default activate current sheet

Hi
Works for me. The Select activates the sheet (as does the Add), so your
code might be creating some other problem before this. Do you really
put in the word "Sector" and the hard coded date, or do you get it from
somewhere else, and are just simplifying the question?

regards
Paul