Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Questions!
Hi All,
1. I would like to create a footer as a table with formulas? 2. How can I create a footer for document (block at the end of the document) different from footer for pages? 3. I have a table with data and I don't know its hight. How can I position my footer at the end of the table (without spaces)? Thanks. -- The Best Regards, ..Net Developer Michael Tkachev |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Questions!
Not exactly sure what you need, but see if any of this helps:
Assume the table has the upper left corner in cell C9 set rng = Range("C9").Current.Region would select the table as long as it is separated from all other filled cells by at least on blank column/row on all sides (or is against the edge of the worksheet). to find the cell below the table set rng1 = rng.offset(rng.rows.count,0)(1,1) -- Regards, Tom Ogilvy "Micharel Tkachev" wrote in message ... Hi All, 1. I would like to create a footer as a table with formulas? 2. How can I create a footer for document (block at the end of the document) different from footer for pages? 3. I have a table with data and I don't know its hight. How can I position my footer at the end of the table (without spaces)? Thanks. -- The Best Regards, .Net Developer Michael Tkachev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Answers to questions posing more questions in a workbook | Excel Worksheet Functions | |||
2 Questions | Excel Discussion (Misc queries) | |||
View Questions and Answer to questions I created | Excel Discussion (Misc queries) | |||
IF questions | Excel Discussion (Misc queries) | |||
Two Questions | New Users to Excel |