Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically appending newly added data on worksheet to a master list worksheet | Links and Linking in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions | |||
Attaching a JET database to an Excel Worksheet OR storing large binary data in a worksheet | Excel Programming |