Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Borders Larry L Excel Discussion (Misc queries) 2 August 11th 09 05:45 PM
Setting borders with a macro orquidea Excel Discussion (Misc queries) 2 January 10th 08 05:21 PM
Borders DAH Mist Excel Discussion (Misc queries) 0 October 1st 07 10:24 PM
Borders Tucker Excel Discussion (Misc queries) 2 May 15th 07 06:41 AM
Borders linda Excel Discussion (Misc queries) 0 January 25th 05 05:31 PM


All times are GMT +1. The time now is 07:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"