Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm fairly new to VBA programming and using Excel 2003. I'm interested in
learning how to make a Macro that creates a number of thick borders across columns "A" to "AA". These borders will divide lines of information from one job number to the next, but the job numbers have a random number of operations assigned to them, each with it's own row. Such as: M1234 - Operation A <next row M1234 -Operation B <next row M1234 - Operation C <next row M1235 Operation A and so on. I am already using some conditional formatting in a few of the columns of the worksheet, so a macro seems my best option. The worksheet is about 1300 rows long, but that is also random, so I'm looking to automatically adjust to the length. Any tips will be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting borders | Excel Discussion (Misc queries) | |||
Conditional Formatting Borders | Excel Discussion (Misc queries) | |||
Conditional Format Borders | Excel Discussion (Misc queries) | |||
Borders and conditional formating | Excel Worksheet Functions | |||
Conditional Borders? | Excel Discussion (Misc queries) |