Find and Replace VBA code not working

[bryden2008]

I am trying to find all no border cells, and replace them with thick box borders.
When I used the find and replace, it replaced some but not all, hence the 5 additional macros added to border what "find and replace" did not perform.

Then, I combined all of the code into one "RunREPLACEGRIDSMacros".

How can I have just one macro that does it all?
Is there something in the cell formatting that would keep the standard "find and replace" (no border cells to thick box borders) from working?
And finally, what is wrong with the code below that I have as a part of "RunREPLACEGRIDSMacros"?

Please Login or Register  to view this content.

Thank you!

[dflak]

I am not sure what you are trying to do here. The code makes no sense at all. You select ranges but immediately activate a single cell and then scroll down from this "fixed" cell. The first 3 lines of code can be replaced with Range("T73").Activate. But you can throw that away, because you then select another range, only to ignore it by activating another single cell. As for the Replacement, it looks like you are trying to replace the null string with the null string.

Replace replaces parts of strings. If you want to draw borders you need to use the various border commands (which I can never remember so I record a macro to get the syntax).

Let's back up and look at the big picture, there may be a better way of doing this. Explain where the data for this sheet comes from, how it is entered, how you intend to use it. There are many ways of doing things in Excel. Often the best way of doing it depends on the context.

[bryden2008]

Hi,
I am trying to replace the thick box border in all cells.

The context is that some of the recipients of this document prefer them and some do not.

[dflak]

Why not just create the sheet with the borders the way you want them?

[Arkadi]

Something like this? :

Please Login or Register  to view this content.

[bryden2008]

I did, but some of the stackholders want the borders, some do not, so I want an option to add and take away without having to do each row, column, cell, etc.

[dflak]

This code should outline the specified ranges on the Map Tab with a thick border.