Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
format table
Hi
I have a standard table format that i use. I want to create a macro that will apply this format when i select a range and run it in this sort of sequence Sub FormatTable() First row within range Format1 Rows 2 to 1 before last Format 2 Last row Format 3 Whole table Border 1 End sub I know how to address ranges, and how to code the formats i need. But dont't know who to tell VBA which part of the range i want to apply formatting to i.e. top row, middle section or bottom row. All help is appreciated. _______________________ Naz, London |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table format | Excel Discussion (Misc queries) | |||
Pivot Table format ! | Excel Discussion (Misc queries) | |||
pivot table format | Excel Discussion (Misc queries) | |||
table format | Excel Discussion (Misc queries) | |||
Data in Cross-Tab format: needs to be written in Table Format | Excel Programming |