Hello. I am kinda new to Excel macros and I am trying to add th
finishing touches to a macro I've designed that produces a report tha
contains a simple four column table in the middle of the page. I wan
the macro to select this table, put borders around it, and add bolde
sums to some of the columns. The hard part is each time the macro i
run, the table length is not the same, meaning it could have 5 rows fo
one report or it could have as many as 50 rows. The top of the table i
always in the same location, so I think I can maneuver with some vba t
select the area but I need your help.

I tried selecting the top left of the table (cell B13) and then using
ActiveCell.CurrentRegion.Select and it almost works, but for som
reason, it also selects the cells directly above my table's headers
which I don't want included.

Here's an example of the simple table. Once the macro has finishe
running, the user will be entering numbers into the blank fields, som
of which contain formulas. I want the macro to put a simple borde
around all the cells and summarize columns C and D, bold those total
and add borders around them too.

______ColB ColC ColD
Row14 Value1 blank blank
Row15 Value2 blank blank
Row16 Value3 blank blank

Thanks for your help!



--
paulol
-----------------------------------------------------------------------
paulold's Profile: http://www.excelforum.com/member.php...fo&userid=3337
View this thread: http://www.excelforum.com/showthread.php?threadid=53207