Thread: Worksheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tjh tjh is offline
external usenet poster
 
Posts: 96
Default Worksheet

Hello,

I am using a listbox to display all the worksheets in a file, I also have
the MultiSelect property set to Multiple selections.

On Initialize I am using the code below to populate the ListBox:
Dim wks As Worksheet
For Each wks In ActiveWorkbook.Worksheets
Me.LSV.AddItem wks.Name
Next wks


Then in the code that uses the worksheet name, I am using the below to
select the sheet but getting an Error:

Worksheets(LSV).Select


How do I fix this??

Thank You,