asked on

VBA For Excel Formatting

I need VBA for eliminating Merged Fields, Wrapped Text, Borders, and Bold formatting for a Worksheet. When I record the macro performing the tasks it creates a macro that is working with Cells, and it creates a macro that is too large for Excel. Can anyone help me please? Thanks. - Tom

ASKER CERTIFIED SOLUTION

Russell Fox

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Farrar

ASKER

Yes, that worked nicely. Thanks, Russell.

SOLUTION

Doug

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Tom Farrar

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for tomfarrar's comment #a41242171

for the following reason:

Thanks again, Russell. I am trying to get a grip on the VBA.

Doug

Note that there's a Clear button on the Home tab of the ribbon that will also do what Russell mentioned.

Russell Fox

No problem, though if it worked for you you should accept an answer as correct rather than requesting a closure.

Tom Farrar

ASKER

Thanks, Doug, perhaps I could have used the 'button" when recording my macro. Sometimes I wonder about myself.

Russell, my apology. How do I make that change. Didn't realize that is what I did.

Russell Fox

That's actually exactly what I did to generate that code: start recording, select all, press clear->formats, select A1, stop recording.

I think I just need to hit the "object" button now and someone will look at it. It's just better for people who might have the same question if they can find an accepted answer here. I suggest splitting points with @Doug.

Tom Farrar

ASKER

Your wish is my command, Russell. I will split the points when I get the okay to do so. Thanks to both of you. - Tom

Tom Farrar

ASKER

Thanks again, All.