pages

I want my user to pick which pages to select. Once they're picked, I can put them into an array, but the SELECT fails. SELECT(ARRAY("Sheet2","Sheet4")) works, but if I build it first, like aSheets = ARRAY("Sheet2","Sheet4") SELECT(aSheets()) it fails on an error 9, subscript out of range. Any...

Hi, I have a little script which prints out a selection of pages from a workbook to my default printer. Private Sub CommandButton1_Click() Dim WS As Worksheet For Each WS In ActiveWorkbook.Worksheets If WS.Range("$A$1") = "Print" Then WS.PrintOut Next WS End Sub Different...

I found this macro: https://stackoverflow.com/questions/39222082/vba-to-find-text-from-webpages I did not understand if it is possible to extract all the links of a web page or if it is possible to extract all the links of a website. I would like to extract all the links of the pages of a...

Hi....thank you for reading and for any help that can be offered. I have an Excel file where the print range is E13:AA1795, with rows 1 - 12 as the headers that repeat on each page. I added filters via macro buttons that filter the report based on criteria in column B. All works well except...

(sorry to start a 3rd post in 2 days...I'm dabbling in foreign excel territory and Google isn't helping). I have a worksheet that spreads over 2 pages. I have command buttons that insert rows as needed in various places. The worksheet is basically spread into 5 sections/categories of items and...

Hi all, I want to add page numbers to my workbook to make life easier when printing around 800 pages. Does anybody know how to design a page numbering code to ignore adding page numbers to specific pages based on a certain condition? The condition that I am requiring is that it ignore all...

The VBA can do the following: 1. Input print pages (e.g. 3,6,4) 2 .VBA can print out as pdf all input pages, but not in order (i.e. 6,3,4). How to modify the VBA so that the print out is in order of input pages, i.e. 3,6,4? Sub PrintSOR() On Error GoTo 1000 ro = ActiveCell.Row co =...

I have a spreadsheet that no matter what size I scale it to in page setup, it prints out the same size on paper. There are multiple pages. Can anyone help me please?

I have combed through google and my excel book for something i am trying to do but can't find how. What i am looking to accomplish should be simple. I have 10 page breaks on my one sheet. All ten pages on my sheet have reports with formulas and links to other cells. But there is a middle...

Hi all Just after some guidance. I have a report template from which i create up to about 25 pdf pages based on different filters. I have a vba loop which basically creates duplicates of the sheet, applies the next filter and then exports everything at the end to a single pdf. Just wondering...

Hi all, Say I have a few pdfs, I list location/file name in cell, 1 pdf file with 5 pages, and a few other pdfs, is there any vba code that can combine this into one pdf? Is this possible?

Please help an old novice out. The last time I was heavy into Excel was before the year had a "2" in the front (1990's). :eeek: I have a Excel questionnaire I've made that has 5 pages to it. The first page has two drop down cells for responses. if either of the two are yes, the other pages need...

Hello, I've only just discovered that I can import data from a web page by: Import External Data ~> New WebQuery Much scarier than the reality in practise! I do however have a question, if the data I want is split across multiple web pages like this one here...

Hi, At work, we have access to certain folders depending on our job role. Currently one of my monthly jobs is to enter data into a workbook from another workbook - a direct copying process that I would love to automate to free me up to do the rest of my job! But the workbook that I'm updating...

Hey Gang I have a macro that selects the print area of a single page in a workbook and emails it to a list. When the page is received and viewed it displays as two pages (Front & back of the page). But when the people receive the page and attempt to print it it defaults to printing 6 pages and...

Hey guys. I haven't done VBA for years - but am trying to help out a colleague. We currently have a sheet with approx. 50 pages. Different businesses want to see different pages printing. Today.. someone goes through and manually works out which pages to print. I have the below sample in...

Afternoon all, Is it possible to change the back ground colour on the multipages ? no default option appears ? also The caption you add to the pages, can that caption be formatted, as I wanted it to appear font size 12 and in bold ? Thanks Pauljj

Hi Everyone, Ok so I have a bit of a problem and hope someone can help me? First let me explain the setup, I Have to produce a PDF the has many pages (Over 200) of different sizes (number of rows) I have set this up manually using Print area and adjusting where the page breaks are but I need...

I cannot figure out how to duplex print 1x3 pages for each worksheet in my workbook. When I select all tabs and each one is formatted to print duplex, on the last of the three pages, I get the next worksheet's first page. Thanks very much.

Hi Excel 2016 -Power Query Need to understand and know How to extract multiple pages data using Power Query. Listing below two websites which has multiple pages of data https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm...