-
resizing borders
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
-
Can you create a dynamic named range? Then record a macro clearing and resetting the borders for this area.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
-
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...
thanks for the help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules