Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formatting a workbook
Please fix your system date
-- Kind regards, Niek Otten "Alistair Johnston" wrote in message ... I need help writing a macro to format a worksheet. We have a text report that is output from our system. We open the report in excel to format it for printing. I want to select a cetain range that is variable with the output. I think what needs to happen is a macro that searches for the headers in the sheet. It then needs to find the end of the data. I guess by finding the next empty cell after the data. It then would autofit the columns, make it bold and justify left. I recorded a macro that selects the whole sheet and then formats it how I want but I would preffer the search method. Thanks for any help Alistair Johnston |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formatting a workbook
Hi Alistair. This article written by Frank Kabel & Bob Phillips may help.
You could possibly paste the code into your macro: http://www.xldynamic.com/source/xld.LastValue.html HTH -- Sincerely, Michael Colvin "Alistair Johnston" wrote: I need help writing a macro to format a worksheet. We have a text report that is output from our system. We open the report in excel to format it for printing. I want to select a cetain range that is variable with the output. I think what needs to happen is a macro that searches for the headers in the sheet. It then needs to find the end of the data. I guess by finding the next empty cell after the data. It then would autofit the columns, make it bold and justify left. I recorded a macro that selects the whole sheet and then formats it how I want but I would preffer the search method. Thanks for any help Alistair Johnston |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formatting a workbook
I need help writing a macro to format a worksheet. We have a text report
that is output from our system. We open the report in excel to format it for printing. I want to select a cetain range that is variable with the output. I think what needs to happen is a macro that searches for the headers in the sheet. It then needs to find the end of the data. I guess by finding the next empty cell after the data. It then would autofit the columns, make it bold and justify left. I recorded a macro that selects the whole sheet and then formats it how I want but I would preffer the search method. Thanks for any help Alistair Johnston |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formatting a workbook
Your welcome. I hope it helps.
-- Sincerely, Michael Colvin "Alistair Johnston" wrote: Michael wrote: Hi Alistair. This article written by Frank Kabel & Bob Phillips may help. You could possibly paste the code into your macro: http://www.xldynamic.com/source/xld.LastValue.html HTH Thanks for the link. I will give it a go and see how I do. ALi |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with formatting a workbook
Michael wrote:
Hi Alistair. This article written by Frank Kabel & Bob Phillips may help. You could possibly paste the code into your macro: http://www.xldynamic.com/source/xld.LastValue.html HTH Thanks for the link. I will give it a go and see how I do. ALi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I SUM TWO CELLS FROM ONE WORKBOOK TO ANOTHER WORKBOOK? | Excel Worksheet Functions | |||
Pulling data from another workbook | Excel Worksheet Functions | |||
Unprotect Workbook | Excel Discussion (Misc queries) | |||
Formatting all sheets in a workbook to print the same | Excel Discussion (Misc queries) | |||
how do I keep a large workbook from losing all formatting upon cl. | Setting up and Configuration of Excel |