irow

All, I have a code that writes to a certain worksheet that we use for data analyzing in click. But now we want to see it as a simple worksheet per customer. Now my VBA scripting is basic, how can i change the following code from writing in rows to columns. Set wsAE = Worksheets("Sheet5") If...

Hello, I am looking to make a code work in the way that it finds the last available empty row in columns A to L since M will have data pull with a formula. But I am not sure how to or where to add the range to make it work. Can I please ave your help? Dim iRow As Long Dim ws As Worksheet Set...

Happy Friday, I'm very familiar with excel, but not so much with VBA. I'm creating a form with drop downs and one "enter" button at the bottom. When I go to test I get a Variable not defined error with PrivateSub CommandButton1_Click() highlited in yellow along with the (x1Down). Help...

evening all having a bit of a problem i have some data that is exported as follows <tbody> 000 012 280 B WEBBING 000 012 499 HOSE 000 050 300 A F7M PAINT PENCIL 000 051 446 AP USB CABLE 000 051 446 Q WIR.HARN. 000 051 700 C BRACKET 000 054 635...

Good Day I have 11 checkboxes on a userform. When I select a checkbox and write the data to excel sheet, the unselected checkboxes return a False Value and the checked is blank in the Sheet whereas it should return True Value which does not. Thanks Code is as follows: Private Sub...

Hi all, I have the following code which I use to read TXT file name/file content to excel file from a location. The problem is that I have some accented characters in TXT files and they end up in excel as "Ä" - "È™" - "" How can I modify the code to specify the encoding or solve this...

Hi all, Im trying to use the following code to open a workbook filter sheet 2 by column b with "5124" and column C with "Job numer:" "Parent Job:" "Project Director:" "Client:" "Totals for Job" Then paste the result in the original active workbook. I havent got as far as the copying and...

Please help before I go mad. I am working on a patient assessment form - there's going to be approximately 80-90 columns of data in each row when it's done. The first part is patient demographics. All I am trying to do is get the next available row. I can't get past the run time error. "Method...

I need to insert a blank row if the left, 3 does not match. the code below, does not separate correctly. Application.ScreenUpdating = False Dim iRow As Integer, iCol As Integer Dim oRng As Range Set oRng = Worksheets("doc1").Range("A2") iRow = oRng.Row iCol = oRng.Column Do ' If...

Hi all, I have found a million solutions to highlight differences, but I'm having trouble finding something that accommodates the addition of a row in the middle of my data. The idea is that I have two sheets with a few dozen columns--let's call these sheets A and B, with B being the newer...

I am working on a UDF that processes a large table of data. A small example might look something like this. <tbody> R/C W X Y Z AA AB AC AD 24 $100 4.5 A Y B33 3/22 250 2005 25 $250 5.8 C N X21 4/15 135 2011 26 $75 1.5 F N R03 3/29 1995 27 $110 6.0 D Y G44 4/20 400 2015 </tbody> The...

I have the following macro Sub AddBlankRows() ' Dim iRow As Integer, iCol As Integer Dim oRng As Range Set oRng = Range("a1") iRow = oRng.Row iCol = oRng.Column Do ' If Cells(iRow + 1, iCol) <> Cells(iRow, iCol) Then Cells(iRow + 1, iCol).EntireRow.Insert shift:=xlDown iRow = iRow +...

Hello everyone! I'm new to VBA and would like some help adding a few lines to my code. I have three worksheet's in a workbook. Two sheets have records, one has pivot tables. This code scans the active sheet and copies all records with unique values per a column and brings it to a new...

I use this code to find existing Names in my data worksheet. Private Sub ComboBox1_AfterUpdate() Dim iRow As Long Dim ws As Worksheet Dim Name As String Dim CLoc As Range Set ws = Worksheets("Members") Name = Me.ComboBox1.Value Set CLoc =...

I have a code where I am pulling data from a sheet and then creating Pie charts based on the data. My proof of concept code uses the following code and works - but is too simple since I need to create 3 charts from each line: With ws .Shapes.AddChart.Select...

I’m attempting to assemble a ws with several columns of data. Macro1 works just fine. Except for the column & iRow cell references, Macro2 appears to me to be the same code. However, it replaces the existing data. Any ideas on how can this be resolved? SubMacro1() Dim FullName As String Dim...

I keep getting a type mismatch error, anyone has any idea why?

I've done some calculations where the output consists of 6 scenarios of 6000 rows of results in 12 separate worksheets. The output for each scenario looks like this, where columns B,C,D would contain values for RMSE, MAE and MASE for scenario 1 and columns G,H,I would contain the values for...

Hey everyone, I have a userform with 3 entry boxes. 1 for a date (ComboBox1) and 2 Text Boxes to update values (dollar values). When I use the code below on my CommandButton to update it is only adding the date, but not adding the other 2 values. What am I missing? I am trying to update columns...

Hello! Right now I have an inventory list that has a macro in it where you can manually add parts onto a reserve so that other people will not use them. Basically you just type in the quantity and the part number and it will look up the part number within the inventory and add whatever quantity...