selecting spreadsheet instead of specific columns

[ds0919]

Hello,

I am new to macros and currently working on a file that is an export from another application. The macro is basically to add lines, reformat, etc. While it is not complicated (for those who are familiar with macros) it does have a lot of steps.

The issue I am having is with trying to format the columns as percentage, currency, etc. When I run the macro as is, it selects columns A-J, instead of just the individual column. At the end of that section, however, the formatting for columns K - N are fine. The section in red is the section I am having issues with.
Any help will be greatly appreciated!!

Please Login or Register  to view this content.

[HaHoBe]

Hi, ds0919,

instead of

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

Ciao,
Holger

[Norie]

What exactly is the problem?

[ds0919]

Holger,

That worked perfectly!!!

Can you tell me if you see other areas that I could condense? I am trying to learn and am doing so one step at a time.

Thanks for your timely and accurate response!!

[HaHoBe]

Hi, ds0919,

as your macro is mostly code from the macro recorder you can avoid the typical going of the recorder: select an item and then work on it. And there is at least one line of code that I sort of dislike (Merge).

untested, an option would be to use BorderAround for the outside borders of the range:

Please Login or Register  to view this content.

Ciao,
Holger