clean code from recorded macro

Hi guys,

I have a wkb and if I make some changes in it and then try to work at office, the hours show "h:mm". I have recorded a macro in order to set "hh:mm" for some cells.
because I have more than 50 sheets is possible ot have it ...shorter than I got it?
the sheets are named as:
"stu-2437"
"stu-567A"
"stu-700ABC"
"stu-item1" to "stu-item12"
I appreciate your help!

regards, Tim

Please Login or Register  to view this content.

Hi tim5, try

Please Login or Register  to view this content.

It's going to affect every sheet in the workbook. If you only want specific sheets affected then add the do something like:

Please Login or Register  to view this content.

Except now you'll have to code for each specific sheet in your workbook. You could probably use Select Case (see here).

This is not tested because I don't have your workbook but perhaps:

Please Login or Register  to view this content.

hi,
I know it affects all sheets, but the range of the others sheets is outside and some of them have text!
thank you for sending me to "Select case", I think it's .... a little bit complicated for me, I'll try to "decrypt" it!

regards, Tim

edit: I see what select means...well, I have too many sheets for using it! I use the first code you provided!
I call you if I encounter problems!

If it doesn't work or you need help understanding it, just let me know.