Edit VBA script to work in multiple specific sheets instead of just one

Hello friends,
The VBA below works for the sheet with the module attached (it converts all data entered in the listed range to ucase). I have a Workbook (MyWorkbook) with ten sheets, named: One, A, Two, B, Three, C, Four, D, Five, E. I want this VBA to work in each of the lettered sheets: A-E, but only those sheets. I don't want to have to create a module with this script in it for each of the 5 sheets.

Can someone show me how it can be changed to work in all 5 of the sheets desired?
THANKS!

Please Login or Register  to view this content.

How about

Please Login or Register  to view this content.

This needs to go in the ThisWorkbook module

Hi

I suppose you need one Private Sub Worksheet_Change for each Worksheet, because the event is design for a Worksheet not for a collection of Worksheets.

I do not know but try

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range).

Thank you very much - that's what it took - so simple (when you know what you're doing).

You're welcome & thanks for the feedback

Thanks for taking the time to reply. Turns out the fella who replied immediately before you solved my problem. It took what you offered PLUS one more IF THEN line of code.