VBA for printing worksheets from cell values

[normanbruce]

I have, what should be, a simple VBA module to incorporate into my spreadsheet but I do not seem to have the proper understanding of VBA to do so. Are there any recommendations as to how to do the following?

I have a number of worksheets within a single workbook. In the first sheet I have a column / range, let’s say A10:A50. I want to enter many names in the column, then have excel look at the names and print the worksheet with the same name, for example if I enter ‘Apple’ ‘Goat’ ‘River’ ‘Fred’ in column A, when I press a button it will print the worksheets names Apple, Goat, River and Fred.

I have limited knowledge with VBA but am really trying to understand it. Any help would be very much appreciated. Thanks.

[daffodil11]

Perhaps:

Please Login or Register  to view this content.