VBA for adding borders to a range based on condition?

Hi Krish -

Thanks a lot, this is way simpler than the approach i was trying to take. I failed to represent in my original post that there is a empty row between each data entry.

___________________________________________________________

7/11/09 Tool1
EMPTY ROW
7/12/09 Tool 1
___________________________________________________________

___________________________________________________________
7/11/09 Tool3
EMPTY ROW
7/12/09 Tool3 etc.
___________________________________________________________


How can account for these empty rows between tool entries and still manage to get the borders around the range of cells for that particular tool?

Thanks

Hi Kris,

Here is the attachment- it pretty much outlines what I'm shooting for.
Mainly just need to figure out how to get the borders to appear around the perimeter of the first and last row a particular tool number appears in.... the blank rows in between shouldn't have a top or bottom border.

Thanks again.

Kris,

It's perfect thanks - it would have been a while before i got this far on my own.... thanks a million!

I've been trying my hardest to apply the macro help I've received to other worksheets I use. With little luck.

Specifically, I have an inventory sheet that isn't vary complicated. I do a custom sort on it and everything condenses rather nicely but it is undreadable. So I've been asked to add empty rows between each line. The macro I am trying to use doesn't effect the entire row, only the first cell and it moves the headers as well. My limited knowledge is a problem in fixing that.

My second macro is meant to place a single box border around all the rows that contain the same ID number - all unique ID's are boxed in together for easier reading. Again, it just isn't working out that way. Mainly because I can't figure out how to alter to box things in correctly.

this is a macro that I'd really like to learn from as this is the kind of thing I get asked to do all the time, and I hate having to do it manually - takes forever.

I know both of these macros work - I got them here from very helpful people and have used them already in other forms successfully. I just don't understand VBA well enough yet to get them to work in a new worksheet with different layouts.


I have attached my workbook - any assistance would be appreciated.

Thanks

Hi Kris,

I get a compiler error stating that the Sub or function is not defined for the second macro.