Hi All,
I need to make a macro that will add borders to certain cells.
I have a generated report from another product so I don't know how many rows there will be until the report is generated. The number of rows is specified inside the report, so I do have access to it. It is stored in cell C5.
So what I want to do is add borders around C5 number of rows starting at A7..E7
I tried using a rule, to just put borders around cells that contain data, but that won't work because sometimes cells are blank and I still want the border around them.
Help?! Please
Thanks a bunch!!!
Lori
I need to make a macro that will add borders to certain cells.
I have a generated report from another product so I don't know how many rows there will be until the report is generated. The number of rows is specified inside the report, so I do have access to it. It is stored in cell C5.
So what I want to do is add borders around C5 number of rows starting at A7..E7
I tried using a rule, to just put borders around cells that contain data, but that won't work because sometimes cells are blank and I still want the border around them.
Help?! Please
Thanks a bunch!!!
Lori