|
-
Aug 30th, 2010, 05:47 AM
#1
Thread Starter
New Member
Please help me
Hello,
I want to make a VBA code for printing out sheets that are listed in a ListBox. I've tried the following loop:
For Each ListBoxItem As ListItem In ListBox1.Items
ActiveWorkbook.Sheets(CStr(ListBoxItem)).PrintOut
Next
This however doesn't work, and I don't know why...
Could you help me with this one? Maybe there are multiple faults in the code...
Jeroen
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|