pages

  1. C

    Scraping web works on same kind of webpage except one.

    My company uses a webpage created by ASP.NET to upload data from difference sources (people). Employees from different regions input data on the webpage and I consolidate the data into a report. I am writing a vba code to pull (scrap) info from the page to an Excel sheet. The first part of...
  2. M

    Print all Odd or all Even pages from multiple sheets

    Someone else sent me this code example and it worked perfectly for the task I was working on. He admitted that he didn't know enough about the workings of the code to offer much advice, but was able to find it for me...so thanks! So I'm using this code for it's intended purpose, but now I'm...
  3. K

    On other pages, the macro that lists a duplicate record of a staff on a "new" page

    Hello all I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro? Thanks in advance for your information.:(...
  4. K

    Bringing duplicate records of single staff on multiple pages in Excel.

    Hello to everyone I have a multi-page excel book. There are duplicate records on the pages. is it possible to transfer the records of the individual personnel to the new page with the macro?
  5. S

    Merge pdf according to the page order indicated in the excel file column

    I have divided a 900-page pdf file into single pages numbered according to the number of pages (1,2,3,4, etc.). I would like to combine only the pages according to the order indicated in column a of the excel sheet (example: 1,2,3,7,8,9,13,14,15 etc.). Is it possible to do this with a macro...
  6. VBE313

    How do you get Listbox Multiselect values to paste into different pages in multiform?

    I have 10 pages of all the same textboxes but named "Page1Reg1.Text" or "Page10Reg.Text" for example. I would like to know if you could have the multiselect values paste in each page. ListBox1.List(ListBox1.ListIndex).Value = .Page1Reg1.Text ListBox1.List(ListBox1.ListIndex).Value =...
  7. J

    Scrap Produt IDs SKUs from category Page Power BI

    below details are given on Source Code page. How can i scrap these SKUs for all pages in that particular category...
  8. J

    Conditional Printing

    Lets say, for example I have a spreadsheet with data in column B-K, and the potential for data in row 1-100. Is there a way, using some sort of flag to tell Excel only to print rows that contain said flag in Column "A"? Alternatively, I know a complete spreadsheet is 10 pages long, if data is...
  9. B

    VBA PDF Export of Large Spreadsheet

    Good Day Gentleman, I am hoping someone could help me out with the problem I am currently having - believe me that it would be beyond appreciated if anyone is willing to offer some of their time to help me with this. Currently I have a very large spreadsheet(Approx 3080 Rows and with approx...
  10. W

    MultiPage problem with multiple pages

    Hi. I got a MultiPage with several pages, and a userform to input data on the next line on spesific sheets, but i got a issue. I've had 4 pages for a long time, no issues what so ever, but then i added more pages, and copied the same code as i used for the 4 others, and just modified the names...
  11. E

    Excel and word

    all the links stopped working to day 14/2/19 when i click on a hyperlink i get the message. cannot load the data to open. I have a file with 400-500 link to facebook pages. only about ten of them follow the link. big help i have tried every thing. thank you Frank Rowley
  12. B

    Printing with page breaks and filters prints blank pages

    I have a range of cells that need to be printed and different ranges are to be printed depending on a filter that has been applied. I have had to set up some manual page breaks to make sure the pages are printed correctly, but the problem I have is when the filters are on there are some blank...
  13. A

    Object Property Setting in Bulk

    I have a worksheet with a multipage object. On each page I have a series of frames, and within those frames a series of checkboxes. Is there a way that I can set the lock properties for all the checkboxes of all the pages without having to set each one on their own? Each of the pages has 50 or...
  14. T

    Delete unwanted excel pages

    Hello everyone , Suppose there is an excel page that I don't want instead of searching for and deleting it manually. Is there a method to delete that page that if it contains a specific (Word) on it? For example, Page 1 : strawberry juice is written inside it , If i have to locate it among...
  15. A

    Named Ranges - Longer than 255 characters

    I have 20 worksheets, named page 1 to 20,with data. To enable me to export a selected number of pages to a .pdf file, I have given a certain range a name. Example, page1 cells A1:G10 and cells A100:G110 the name is Page1 but ( Page1_A1:G10,A100:G110 when viewed in the name manager) I then...
  16. S

    Userform Pages

    Hi, I have a user form with a number of pages within it. When I click on the tab to a different page, the userform scrolls so that the start of the page is right a the top. Is there any to make sure that it's scrolled to the top of the userform? Stephen.
  17. M

    Pausing a Print macro and fixing print range

    OK have a print macro that works well and combined it with Post #12 from https://www.mrexcel.com/forum/excel-questions/39788-old-excel-macro-language-2.html with a slight modification. This is it from my spreadsheet Application.Wait (Now + TimeValue("0:00:20")) Application.Goto...
  18. lmmay

    Printing Pages in one Worksheet

    I really need help on this one. I have a worksheet form with headings. I have an "Add Page" macro copying the form from a second sheet. The worksheet will have between 1 and 20 pages needing to be printed. The page needs to be scaled to 49%, each page is 61 rows. Can someone please provide a...
  19. D

    Printing tab page numbers

    Hi, Sorry if this has been asked before. I have a workbook with multiple tabs of varying numbers of pages. What I'd like to do is highlight the tabs and print them all as 1,2, 3 etc of total pages numbers for that tab as opposed to the total pages for all the tabs highlighted. I want to avoid...
  20. F

    Importing table from Web with multiple pages

    Hi I’m working on importing a table from a web however the issue I am having is that the table is divided into pages based on the number of records . I need my my excel workbook to be able to import all the records into the workbook regardless of the fact they are dividing up into pages with...

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