page

Sometimes we need to know the addresses of all the pages that make up a worksheet. The code below lists them and offers an option to colour each page differently. Sub Main2() PageAddress2 True End Sub Sub PageAddress2(colorcode As Boolean) Dim c%, v%, h%, cln%, rw%, hgth%, wth%, i%, ws As...

Hi, I have been searching with no luck to find a solution to copying/pasting data from an open chrome web page. I have chrome web page open (the web page has a title, so hoping to use the title). On the page there are columns with headers and columns of data. I'd like to select certain columns...

Hello, I'm trying to do a simple web query for a couple of sites, but however their tables are coded, it only queries the first page of the table rather than all results. When clicking to the next page of the table (or selecting to view all rows), the page URL doesn't change, which eliminates a...

Hi all, I'm looking some help with referencing a combo box in a outlook form. I have a total of 4 pages/tabs, the first is where the user will select from a combo box and depending on which option is selected this will navigate the user to the correct page. I've never used vba in a outlook form...

Morning, I have this is place at present. Private Sub Worksheet_Activate() Range("G13").Activate End Sub How can it be changed so i also see the 12 rows before it on the page. I mean sometimes even though cell G13 is selected its could be 1 inch down from the top of the page & i then...

I have a page break that is making the first page very small, I have tried everything to delete it and nothing works. Heeeellllpppp!!!

Hi, Thanks for looking at my question. I am working in Excel 2016. I want to look up a specific cell value from among a range of worksheets (in the same workbook) and have it return the worksheet name the value is found on. The sample page from the workbook is in the link below, i tried to...

Hi All, I am getting publish error (.Publish (True))in below code in Clinet enviornment, However it working fine on my system. Even if i am trying to creating a HTML page manually, it is showing as "Page can't be displayed". Can anyone suggest here what setting needs to change for fix this...

Hi, I have a long list in column E which is say 1000 + results down the page. I am in need of a Return to top of page code BUT a floating type if possible. I mean the Return to top icon which will hold the code must be in view on the worksheet whether i am on row 55, 239 or 850 then i can...

Hello everyone, I'm assuming this is the ideal function, but I could be way off. Issue on "data" page: Need name of employee (column E) to register a "Division" (e.g. Administrative, Maintenance, Shipping, Production) in another Cell (column W) On "Employees" page I have a the four "division"...

Im pretty new to VBA coding and searching on online and youtube hasnt yielded much help, as they all have their own way to do it and its been very confusing. I can do this via "Data > Get External Data > From Web" but its pulls in way more then what I need, as it picks the whole page and not...

I am an electrical contractor that uses excel to quote jobs. I am getting sick of looking on homedepot.com to check prices. I am looking for a way to have look up the price for me. I tried data from web and putting the website in there but I always get errors on the page and I cant add the...

Is it possible to centre a worksheet on the page and have only that page visible? I tried to hide the pages but greyed out pages are still visible. I want nothing to be visible, except the active page and I would like it centred on the page. Can someone help me please? Is there a way to publish...

Good Day, I have button when clicked it prints a range of rows on a template. Application.Dialogs(xlDialogPrint).Show RowCount = Range("B2") Worksheets("Payslips").Select For i = 1 To RowCount Step 5 Range("B4").Value = i ActiveSheet.PrintOut...

I have a sheet with about 20 tables of data (one table per tenant), and I would like it to print as many of these tables as can fit on one sheet, but I don't want it to split any of the tables across two sheets. For example, if page 1 could feasibly fit 2.5 tables of data, I would want page 1 to...

When I click the Data...From Web option in Excel 2007, it launches an internal "browser" that I'm supposed to use to navigate to the site that I want to grab data from. The problem is that this built-in browser uses MSN.com as its default "home" page, and it generates several (sometimes 5+)...

I have a file that i was wondering if there was a way to write this code differently or easier. The file has 7 worksheets and a button page. i want to clear all worksheet and end up on cell A2 of the button page. Here is the code: Dim sht As Worksheet For Each sht In ActiveWorkbook.Sheets...

Hi, I'm using Power Query for Power BI Desktop and when I connect to a single PDF file the last record only shows the data for the first page and not the rest of the pages. The rest of the data is the same as the first page. Can Power Query read multiple pages for one PDF? If so, how can I...

Basically, what I want to do is have one cell on the first of 8 sheets be the decider for all 8 sheets. Like you pick the cell color in M8 on the first page and that color is carried over to the appropriate spots on all 8 pages. But, I want this to be automated, like once it's selected its...

Hello, I would like to print attached sheet with frozen panes (two rows + five columns) on one A4 as follows. I have set print titles according to instructions on this page. https://excel.tips.net/T002702_Printing_Just_the_Visible_Data.html Afterthat I select range F3:AC10 and then print...