Macro to format only cells with data

[sparkle]

I have a macro that retrieves data from multiple sheets into a summary sheet. I tried using the macro recorder to get code for formatting my data. But the number of rows in my results varies and I need to add borders to only the rows that have data in them. How do I get the formatting to apply to only the cells with data in them?

Let me know if you need more info.

[JBeaucaire]

The answer might vary a little from command to command depending on the formatting. It would be safer if you mocked up a 10-20 row BEFORE/AFTER sample so we can see that you really mean what you say mean, people often say one thing and mean something slightly different when you look at it.

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

[sparkle]

basically I just want top and bottom borders on each row.

see attached.

[JBeaucaire]

See what I mean? There's no data in column B but you added borders to it...

Based on what you actually said:

Please Login or Register  to view this content.

Based on what you showed:

Please Login or Register  to view this content.

[sparkle]

Thanks for giving me the start. I figured it out using macro recorder and what you gave me. I don't know if all the code is necessary but it works so i'm happy.

Please Login or Register  to view this content.

[sparkle]

Either way is fine actually. I was just leaving some cells blank to see what would happen when I tried to figure it out on my own with test data. The actual data has no blank cells so it's a mute point. But I like learning the difference and thank you for that input.

[JBeaucaire]

Your recorded example and the one I gave show how much can be taken out of recorded macros. Your recorded version is setting xlNone on every parameter for probably no reason. If there really ARE preexisting borders to be removed, you can still do that with one line of code.

Also, you don't really need to set the LineStyle to xlContinuous since that is the default, just applying a weight will do that by default.

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.