Macro to put brackets around negative numbers not working

Hi everyone,

I have been manually formatting each worksheet in this workbook so that negative numbers are in brackets and I'd like to record a macro so that it can automate it through out the worksheet as I have 30 other files that would need this formatting. After recording my actions, it seems that the format doesn't change at all on the new worksheets. Attached to the post is my file and here is my code:

Please Login or Register  to view this content.

Thanks!

Why struggle with VBA when you can just use a normal format for the cells. i.e.

Formula:

Please Login or Register  to view this content.

Hi,

I can't see why you just can't select all the cells and manually format them with the format I gave you and have done with it.

However if you must have a macro then simply

Please Login or Register  to view this content.

I got it to work!! Thank you so much! I'm fairly new to Excel outside of the school environment but am working a summer internship where I have time to learn more. You're right, I could have done it manually but doing so for 260 worksheets (10 worksheets for 26 files) would not have been a fun. Thank you for making my life easier and I'm hoping to learn more about vba and macros soon. It's my second week on the job trying out macros!

My final code:

Please Login or Register  to view this content.

OK,

Well done.

One final comment. Rarely do you need to use .Select or .Activate stuff. I know that's what the macro recorder captures but that's because it has nothing else to work with. Using .Select & Activate slows down VBA as well. You could safely remove the ws.Activate line of code.

Please note the forum rule about wrapping code inside code tags when posting code. Click the # symbol so that it aligns neatly making it easier to read, particularly when there are several lines of code.