Column Width Macro

[danigurl]

Please forgive me if my question sounds too much like a beginner because that's exactly what I am, a VBA beginner. I'd like to create a macro in excel for setting a column width but I am not sure how to set up the macro so that I can use it for any column and set the width for any number. When I created a macro using the good old keystrokes method, the macro made my column selection part of the macro so I could only use the macro on that certain column, and it permanently set the column width at 3 because that was the width I wanted to set the column I was using. Does anyone have an idea how I can set up this macro so it will be useful universally? I would really appreciate any help anyone can give me.

Thanks so much
DANIGURL

[jeffreybrown]

Hello DaniGurl & Welcome to the board,

How about something like this...

Select the column and then run this macro.

Please Login or Register  to view this content.

[shg]

Why not just right-click the column(s) and select Column Width?

@Jeffrey: should use a Single rather than a Long.

[jeffreybrown]

Thanks shg,

I see...I think

It's not because of size limitations, it's because a single will be able to handle the decimal point. Such as if they wanted the column to be 8.34.

Is this right?

[shg]

Right. Excel will not, in general, set the column with to exactly what you specify, but you can have decimal widths.