page numbers

Hi All, I am new to VBA and am really struggling to work this one out. I am creating a document in excel which I want when printed to look like a normal word document or PDF. So far the formatting for this is going well but I have found a hiccup when trying to create a Table of Contents sheet...

Hi there, I'm not sure the best way to go about this. I have totals on one sheet and the breakdown is on another sheet. Next to the totals, I want to state which pages they should refer to for a breakdown of that figure. Sheet: SkyCity Invoice A21:A120 Contains Department Name Sheet: SkyCity...

Hi all, Can somebody please fix a problem that has ailed me for more than a year!? I need a code designed that will ensure that all worksheets in a workbook will have even page numbers... With this I was thinking a VBA code that will read the content of each worksheet and assign a page number...

I have a workbook with several tabs where the page numbers all need to be in the lower right footer in lower case Roman Numerals. The code I used is below. The page numbers are only on the 1st page of the document. I need them to number consecutively across all tabs. Right now I am only getting...

I need help with adding page numbers to individual tabs and ranges in a single workbook. Background: One workbook 160 tabs in total 7 tabs with at least 5 report ranges each The problem: Page 1 is on one tab, Page 2 may refer to a range on tab 8, Page 3 is the range on tab 4, and page 5 is...

Hi everyone. I need a method or function that can count the TOTAL number of pages to that will be printed. I don't need anything with HPageBreaks or Get.document(50, ""sheet name"")") for these don't seem to work on my worksheet. All they seem to do is give me a number lower then the number of...

Hello all, I would like to be able to update the page number in a repeating print area and have a single printout command to produce a single pdf file. The print area is fixed and I know the number of pages (3). There is a cell where the user can input the first page number to be used. Here...

I have spreadsheet with various sheets that print as a book. So sheet1 will be the Cover, sheet2 the Index, sheet3 the first report, etc. Each sheet is not 1 page. The page numbers have to follow on each other. So I've found a macro to calculate how many pages there are per sheet...

Hi, I am trying to create an index in Excel. Basically Column A has names in it and Column B will have page numbers. I have 9 tabs. Is there a way for Excel to let me know the page number(s) the names are on and insert them into column B? Thanks for your help!