PDA

View Full Version : resizing borders



fbastian
09-01-2008, 11:03 PM
Hi all,

I am after a macro which will resize the borders of 3 separated sets of fields.
Everytime i update this particular spreadsheet, i add an extra column to it and this is where this macro would come in handy.

The spreadsheet is too big otherwise i'd attach it here....

Thanks :beerchug:

mdmackillop
09-02-2008, 12:13 AM
Can you create a dynamic named range? Then record a macro clearing and resetting the borders for this area.

fbastian
09-02-2008, 01:10 AM
perhaps this will help...
here is a snapshot of the spreadsheet...
the borders which i want to extend using a macro are clearly shown in this file.
i dont know much about macros...:dunno
thanks for the help.