wend

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

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

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

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

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

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

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

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