pages

Thanks for looking at my post. I would like to have some code so I can do the following. I would like to have a box pop up with the option to replace a random page in my work book by entering the page number in dialog box. I want the page that will be replacing the old one to be renamed to old...

Hello, I am trying to print out multiple worksheets at a time. The sheets themselves have footers for the length of the sheet depending on how many lines it has (these are report type documents so they very in number of rows). When I try to print a group of sheets, it prints out the page...

Hello everyone, i would like to know if there is any way to copy specific data needed from multiple pages on a site. This are 3 examples of the pages I need to scrap de data from: https://www.fundoodata.com/companies-detail/Akshaya-Furniture-Pvt-Ltd/65014.html?&pageno=298...

Hello, when i set page title to print each page then i found in printing preview it need to print empty pages also, one more thing, it didn't include new rows in the printing (i.e. it didn't increase the no. of pages to cover the new data). appreciate the help. Thanks:)

I have this file which, in page break preview, shows only two pages, page 1 and page 2, enclosed by blue lines. Page 2 isn't a full page, only about half a page. Nowhere can page 3 be seen. However, when printing, it gives 3 pages, the last page being blank. In print preview, it shows in the...

I want a macro to save xlsm to pdf in range. I have this macro but many times the range changes. It is better to say the pages. For example my macro save the sheet from 1 to 30 page. But I gave the range of these pages not the number. First is hot to write it as pages. And second how can i...

Through this page I received excellent assistance getting a VBA to print the pages from my call schedule. I copy forward each month and make changes and it works great!!!! Until this month when it started adding blank pages. In particular 4 blank pages with the appropriate footer after the...

A few days ago I posted on here asking for help with a basic macro to copy info from one page to the other then print. It worked well until I needed to add one more area to copy and paste. It is copying info from a column that when a number is typed in the top cell, it auto increments with a...

Hey! I need to extract data from a website, but the data on it has a limit of 99 rows of data per page, and so i need to get data from multiple pages. The website requires credentials, and i have my own secured credentials for work. Using Excel's "Get data from Web" option, the data is pulled...

Is there a way with VBA that I can identify if a row will split over 2 pages once populated?

I am using an add-in called Factset which I refresh on a global basis (multiple sheets in the workbook) with the following line of codeExecuteExcel4Macro "FDSFORCERECALC(FALSE)"This code executes a refresh across the whole worksheet but I need to be able to run a refresh on individual pages...

I have a data set that this the ouput from a 2-d flow model. In places where the river is not deep enough I get a result of -9999. At some flows the river is largely dry and most of what I get are -9999s. The output is a 2000 x 2000 (or so) matrices that are mostly -9999. What I want to do...

Hi! I'm having a hard time with the way Excel scales worksheets for printing. I'm trying to create a narrative report which has 16 pages, to be printed first to a PDF using a virtual printer, and then on A4 paper using a plastic-and-circuit-boards printer. (Yes, it has to be created in Excel...

Hi, I have the following code to print pages 1 and 2 of any sheet named with a 4-digit number ... For Each ws In ThisWorkbook.Worksheets If ws.Name Like "#####" Then ws.Range("P22:U22").Font.Color = vbWhite ws.Range("P22:U22").Interior.Color = vbWhite...

I currently have a multi page user form made up of 2 pages which I would like to print when clicking on a command button on the 1st page of the user form. I have the following code which allows me to print both pages of the user form but on seperate pages. Private Sub CommandButton1_Click()...

Hi there, I have 10 pages in my workbook - made up of 5 tabs each with 2 pages When I select all tabs and go to print, they sequentially number 1 - 10 (I have set up a Footer with "Page &[Page]" to do this) I want the first page to be number 7 - so change the First Page Number from 'Auto' to...

Hi folks, I found on this forum a fantastic piece of code to set the page setup of a particular sheet in my workbook. Sub Print_Format() Dim LR As Long LR = Range("A" & Rows.Count).End(xlUp).Row With ActiveSheet.PageSetup .PrintTitleRows = "1:1" .PrintArea = "A1:I" & LR .LeftMargin...

Hi, My excel VBA skillls are very poor. I managed to construct a simple code to pull from one of the required pages, but I need a code that is both efficient (will not kill my computer RAM) and/or dynamic OR simply pulls data from all pages. Every week I pull a data table from a link such as...

Hi all! A little stuck but I'll give as much info as I can. Version: Excel 2016 I have a range of data from A1:N44 that need to be copied into the next columns thus creating a new page. I've been able to get it to work creating multiple pages but can't for the life of me figure out deleting...