pages

  1. B

    VBA-Replace Page with a Page in same Workbook

    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...
  2. B

    Footer format with group worksheet print

    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...
  3. J

    Copy certain data from multiple pages on a site

    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...
  4. A

    How to privet printing empty pages ?

    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:)
  5. Y

    page break preview says 2 pages, print preview says 3

    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...
  6. K

    save xlsm to pdf in pages

    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...
  7. M

    VBA was working fine. now adding blank pages

    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...
  8. A

    Copy and paste macro partially working

    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...
  9. G

    How to get multiple pages of live data from javascript website

    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...
  10. sharky12345

    Identify if row will split over 2 pages

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

    Refreshing FactSet Codes/Functions

    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...
  12. S

    Deleting Cells that have a value in them

    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...
  13. A

    Cell dimensions and print scaling

    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...
  14. P

    small adjustment needed for Printing code

    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...
  15. 8

    Multi page UserForm Print

    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()...
  16. A

    Page Numbers Sequential (but then repeating numbers?!)

    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...
  17. I

    VBA for page setup with dynamic number of pages tall

    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...
  18. H

    Pulling data table from multiple pages

    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...
  19. T

    VBA Copy/Paste/Delete multiple times into next available column

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top