step

Hey hey everyone, I wonder if anyone can help. I have a range (about 11 columns and potentially thousands of rows) which I've copied a formula which could give a result of "" into then copied and pasted as values. Simple enough. But what I need to do now is delete the "blank" cells and replace...

I'm trying to change this loop a bit but can seem to get it to where it needs to be. At the moment i have it going through columns L To Y and down to get the filter criteria and filter but id like to place all 42 net to each other across the top so columns Sub Sort() Dim i As Long Dim j As...

Hello, I am trying to figure out a bit of code which will fit into a much larger module. Basically I have an Excel Table, for which the Header Row is in row 6. The table may or may not be filtered. I want to be able to find the row number of the 25th visible row (even if it is blank and...

HI, I have the following code that i am using. It works when i do step by step but when i try to auto do it, it comes up with a blank screen. Sub Second_Pivot() ' ' Pivot2 Macro ' ' Sheets("Pivot1").Select Columns("A:C").Select Selection.Copy Sheets("Pivot2").Select...

I want to VBA Solver search parameter array like as 5, 8, 11, 14, 17...60 step 3, I use SolverAdd code as follow but not work?Why [W4] as parameter start 5 Range("step") = 3 SolverAdd CellRef:=[W4], Relation:=2, FormulaText:=2+Range("step")*Int([W4]/Range("step"))

Hello, I am really going to do my best to explain this problem I am having, Also I have searched this site and others found nothing but maybe I am searching with the wrong terms. I have a main workbook that uses several other workbooks to save/archive information, several of the operations...

Hi all, I’m trying to delete the hidden rows and columns from thebelow table. I run a macro to autofilter 2 of the columns (8 & 10) but other than that it is unchanged. The original table is extracted from another document. I’vetried using the below VBA code that I found online however I get...

Hi, I am trying to delete rows that have a zero value in column E. I have tried various methods and keep getting 'object does not support this property or method' or 'type mismatch errors. Currently I have: For deleterow = .Range("E" & Rows.Count).End(xlUp).Row To 1 Step -1 If .Range("E" &...

Hello I want a macro to find a value in a list then carryout further steps. If value is found proceed to step 1. If value is not found proceed to step 2. So far I have no problem if value is found, but if value is not found as expected I get run-time error 91, at this point I want to proceed...

Hi all, would anybody be willing to help me create a user form... I already have an excel sheet created with various vba codes and macros but I’m looking at trying to go that one step further. Unless anyone has any other suggestions...? Thanks.

We have certain processes at work that have several steps and also span several days. We often take too much time for one step which in turn eats into the time that we have for other steps. I am developing a spread sheet that allows us to ensure that we only spend a certain time on each step. I...

Hi all...my name is Doug. I have been dabbling in VBA for a couple years and probably been a guest on here a bunch of times. I am new member today! I have some code to fill in a bunch of cells with number incremented by a specified value. It is pretty basic stuff but I have found that it...

Hello, I have a code that works perfectly every time when I step through it, however when I play it normally it does not. It will save a white image rather than the range. This code saves a range as a .PNG. It took me forever to find one that worked the way I want it to. What I like about this...

Morning, I have a range of cells that show the inputs and outputs by steps. What I want the formula to do is grab the first input given and then grab the last output from the range. The problem I have is that the process of the output may vary depending on which process it went through...

Hi, I want to download the data in excel from the below link (inside the link it has 2 more steps) and save it in Birt folder “C:\Users\E5554593\Desktop\A5554593\Birt report” Url: http://147.249.55.189/birt-viewer/ 1st step :- Click on “RealTime SLA - Role/Business Unit” 2nd step :- Click on...

I just wanted to run by a few ideas with the community real quick before I spent a bunch of time creating something that may or may even be possible. I was kicking around an idea where we could have our employees fill out a form in their truck's tablet that would get sent to our share point on...

Here is the challenge (maybe not for some): I am looking for a way to automate some of the manual steps for a daily task using formulas, VBA/Macro. For the task, the basic steps are the following: Step one: find specific accounts such as accounts begin with "051- something" Step two: highlight...

Hello all Can you help on this please This loop formula start at row 13 and then step through every 5 rows For p = 13 To 3251 Step 5 Cells(s, 4).Resize(, 12).FormulaR1C1 = "=IF(R[-2]C="""","""",R[-2]C-R[-1]C)" Next p This time I am looking for a loop that starts at row 13 but only in...

I am new to writing macros and am trying to write one that looks at column H and looks for the response of No and then takes that whole row and moves it to a new tab and then repeats that step for the remainder of the data. Any help would be appreciated or pointers on writing macros.

I am working on a project where I am trying to add up times and dates together. Below is the data that I am working with. <tbody> Steps Time Length (Days) Time Length Converted to (H:MM) Step 1 0.33333 2:40 Step 2 2.16667 17:20 Step 3 0.33333 2:40 Step 4 0.29167 2:20 Step 5 7.97917...