View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 156
Default Activate a Worksheet

what is the name of the sheet exactly the way that it appears in the
tab...also let me see the code that this is in, from dimming the two
strings to calling the workbook and worksheet, and I'll see what may be
going on

Sandy
Sean wrote:
Sandy wrote:
Replace Sheets(wsName).Select
with WorkSheets(wsName).Select

Sandy


That didn't work. It still does not Select the Sheet