step

Hi All, I'm experiencing a problem where power query slowed down after I merged two tables. Since the merge, each time I do a step, it appears its recalculating or refreshing something in the back ground. the refresh stops when it reaches 120MB which takes about 5 to 10 minutes. So basically...

<tbody> w x y z aa 8 251 -108 159 9 -231 118 -149 10 </tbody> What is the correct way to enter the following multi step fx to satisfy the following: In cell Z8 = IF W8 is > 0 AND X8 < 0, OR IF W8 < 0 AND X8 > 0, AND X8 <=-150, THEN 1, "" In cell AA8 = IF W8 is > 0 AND X8 <0...

I have this code that almost works, but has one issue. I think i know why, but dont know how to fix it. As dates are entered elsewhere, G11 counts them. When G11 = G16, it throws up the MsgBox. So far so good. When I hit 'OK' on the MsgBox, Step 1 occurs (saves the file), but then the MsgBox...

The following code has worked before, but now it doesn't and I can't figure out why. I just determine the value in the activecell and if it's more than one I just copy the row and insert it below the selected row, but for some reason I get a runtime error 1004 and the insert method fails. I...

Hi, I am trying to understand what does the vba do in the highlighted section: For i = LastRow To 2 Step -1 If WorksheetFunction.CountIf(Range(Cells(2, "C"), Cells(i, "C")), Cells(i, "C")) > 1 Then Rows(i).Delete End If Next I Kind Regards, Dan

Help please I urgently need a a macro if possible to run this but if there is another way that is fine. I struggled yesterday to find a way. I have a list of items in column AF4 to AF763 I need to copy each one 6 times into column AK4 and then step 20 the start of next one in list then repeat...

Hi there I hope that someone out there will be able to help me with what I think might be a bit of a complex macro (at least more comples than I am capable off :)) I will try to break down the requirements in a numbers of steps, please feel free to ask any questions for further details. Step...

Good day, I have a next step list where each next step listed has a comment section in column G, the comment section is usually only one cell with the text. Every meeting the feedback must be captured with today's date then feedback from the project manager and then if next step is not...

Hello all, So I'm trying to do something a little bit complex but am not sure how to tackle it as I'm very new to VBA coding syntax (but intermediately experienced in other programming languages) Basically, I am trying to parse through this text: <Start> <Step> <Description>...

Building a macro that will refresh a query (with existing extension), take the results (anywhere from 50,000-100,000 lines), and copy to a different spreadsheet. The macro works, but the query refresh takes so long that the macro moves on without waiting for it to finish. Is there a way to...

I have a line of code which works. Do... If .....then Exit Do When the code is satisfied the loop stops, but I want it to move on to a next step and I am not sure how to do this.

Greeting Everyone, Long time lurker, first time poster. Thought I'd reach out for once. I understand VBA okay enough to figure out most issues on my own. I'm not a beginner, but I would't say I'm at a solid intermediate level either. I’m having trouble finding good code examples for this...

Hi, everybody I obtained the foll. code from a book by a well-known Excel MVP and author. So, I found it a bit strange why it does not work. I copied the code from both its web-site and from the book. Sub Macro47() 'Step 1: Declare your variables Dim MyRange As Range Dim MyCell As...

Dim myURL As String myURL = "http://test/Fxrates.xlsx" Dim HttpReq As Object Set HttpReq = CreateObject("Microsoft.XMLHTTP") HttpReq.Open "GET", myURL, False, "username", "password" HttpReq.send myURL = HttpReq.responseBody If HttpReq.Status = 200 Then Set oStrm =...

Cant't get this to work. Looking for code to automatically go to cell A1 (actually range A1:K1 because it's a merged cell) when I click on one particular sheet tab at any time and every time. Hope someone can help This is what I have that works only when I debug it step by step. Sub Move2A1()...

it's a simple macro that simply opens a workbook then copy and pastes to the spreadsheet if i just run it, it often crashes...but if I run it step by step till the end, it's fine. it's driving me insane.

Hi All, I'm practicing VBA for a while now as a hobby and I want it to take a stepfurther. I want to extractdata from a website but the first step is login. Do you know howI’m able to login with username and password on the website below? https://login.transporeon.com/login/ Thanks...

Good day, I'm looking for some advice on how to do the following: I have a range variable named rYvalues to which I assign a range which can be of varying length (7 rows to 365 rows). I would like to do the following: step 1 - divide the range up into sections, the number of which is taken...

I have to create a work plan spreadsheet that tracks tasks, which have steps. <tbody> Task X Status Step 1 1. Status 1 Step 2 2. Status 2 Step 3 3. Status 3 Step 4 4. Status 4 Step 5 5. Status 5 Step 6 6. Status 6 </tbody> As each staff member completes the step, they will...

The following code for deleting blank rows within a range has stopped working for me. I need help with direction for how to make it start working again. Here is the message dialog box that popped up when I did a "Step In" to see if I could figure out what was wrong with the code: Run-time...