Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to add borders
Hi Group
I need to create a large number of spreadsheets that simply consist of a set of grids (double-line borders). These will range from 1 square x 1 square to a maximum of 25 x 25 with every option in between. i.e. 1x1, 1x2, 1x3...1x25, 2x1, 2x2, 2x3...2x25, 3x1...I guess that you have the idea. Now, rather than doing all this manually when I could be doing much more interesting things such as drinking beer in the pub, I wondered whether this could be done via a macro or VBA such that, for example, I enter the number of rows & columns in two cells, run the macro & it produces the grid for me. If any of you have any ideas, they would be gratefully received & I can look forward to my beer! Regards Colin Foster |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a macro to add borders
A further thought... each of th egrids needs to be a square, rather than the
rectangles that the Excel grid appears as! Regards Colin "Colin Foster" wrote in message ... Hi Group I need to create a large number of spreadsheets that simply consist of a set of grids (double-line borders). These will range from 1 square x 1 square to a maximum of 25 x 25 with every option in between. i.e. 1x1, 1x2, 1x3...1x25, 2x1, 2x2, 2x3...2x25, 3x1...I guess that you have the idea. Now, rather than doing all this manually when I could be doing much more interesting things such as drinking beer in the pub, I wondered whether this could be done via a macro or VBA such that, for example, I enter the number of rows & columns in two cells, run the macro & it produces the grid for me. If any of you have any ideas, they would be gratefully received & I can look forward to my beer! Regards Colin Foster |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Borders | Excel Discussion (Misc queries) | |||
Setting borders with a macro | Excel Discussion (Misc queries) | |||
Borders | Excel Discussion (Misc queries) | |||
Borders | Excel Discussion (Misc queries) | |||
Borders | Excel Discussion (Misc queries) |