wend

  1. J

    While Wend Statement

    Hi, Can one use AND in a while wend statement: When I use this statement, it does not read the AND statement, so even though there is data in my last column it exits the loops. Not too sure what I am doing wrong, or if I should not be using While and AND in the same statement. Any advice...
  2. ExcelNooberino

    HTML Macro to print documents

    Hello everyone! So I've come up with the idea of trying to create a macro that allows me to open a few PDF documents from a intranet website here in the company I'm currently working in. The code below is what I have so far, and it's working perfectly but, I need to sort the table by one of the...
  3. steveuk87

    IE browsing and user field manipulation

    Hi All, I have the following code: Sub NewTest() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("my website") While .Busy Or .readyState <> 4: DoEvents: Wend...
  4. steveuk87

    IE browsing and user field manipuilation

    Hi All, I have the following code: Sub NewTest() Dim IE As Object Set IE = CreateObject("InternetExplorer.application") With IE .Visible = True .navigate ("my website") While .Busy Or .readyState <> 4: DoEvents: Wend...
  5. P

    Web Scraping with VBA - problems clicking a button (button is only class)

    So i got everything working to go to the website, enter in the username and password but i don't know how to change this so that it clicks the "sign in" button. Private Sub Open_multiple_sub_pages_from_main_page() Dim i As Long Dim IE As Object Dim Doc As Object Dim objElement As Object...
  6. S

    Macro not printing

    I am trying to run the macro below, but it doesnt seem to be printing. What is wrong with it ? Option Explicit Sub test() Dim i As Integer i = 1 While Sheets(2).Cells(i, 1).Value <> "" Sheets(1).Cells(1, 1).Value = Sheets(2).Cells(i, 1).Value Sheets(1).PrintOut...
  7. P

    VBA Virtual Loop

    Hello, How do I write code to move on to another question if the information doesn't exist on my spreadsheet? My code is: 'Select Start of range Range("B1").Select While ActiveCell.Value <> "" 'This writes 'Cash' in column A against cash transactions. If ActiveCell.Value <> "" Then...
  8. Z

    macro runs when stepped through but deletes rows of original table when run with f5

    Hi all, New to excel and can't figure out why this macro deletes some of my rows when it is run. Any help appreciated . My original data is across two sheets with first sheet having 19 columns with columns I to S housing numbers that are manipulated to calculate cash which is inputted in the...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
Top