a.value

First, I should point out I'm using Excel for Mac. So I've gone to File, Import, CSV file, selected the file and it has imported successfully on my spreadsheet. I've also got a Macro set up so every few seconds it checks for updates and refreshes the imported data. I'm trying to make it so if...

Hello, Can someone please help me with this? I am using a Dim statement in VBA but would like to expand my text to the next column over. Here's what I have so far: Sub CommercialMarketPlace() ActiveSheet.Select Dim a As Long For a = 1 To Cells(Rows.Count, "S").End(xlUp).Row If Range("S" &...

Hello Friends, As the title says, I want to create a command button that when clicked, will generate a sequential number starting from 1. This is what I have coded for it Private Sub CommandButton1_Click() If CurrentRow = 5 Then ThisWorkbook.Worksheets("FR").Cells(CurrentRow...

Hello, everyone.. i need some help to make this repetitive VBA into a very simple VBA My repetitive VBA were shown as below If Target.Address = "$L$6" Then a = Sheets("Price Record").Cells(Rows.Count, "A").End(xlUp).Row + 1 Sheets("Price Record").Range("A" & a).Value =...

Hello, Have a situation developing here. There is one sheet "CT" which has a list of products and the dates next to them. The list is incomplete and I need to fill criteria from another sheet, "PP" This is what I have so far. Dim Lastrow As Long, Row As Long Set ct = Worksheets("Campaign...

I am such a VBA noob. ML.Activate Do Until Cells(ActiveCell.Row, "A") = "" tnam = Cells(ActiveCell.Row, "H").Value tno = Cells(ActiveCell.Row, "A").Value pup = Cells(ActiveCell.Row, "G").Value pp.Activate Range("A3").Activate Do Until Cells(ActiveCell.Row...

I have a table of data which contains address fields across columns C to F. Column C will always be the first line of the address which is fine, however, the postcode, which needs to be in column F, can be in either D, E or F. What I need is code that can start with a Do Until, end in a...

I have a folder with 40 text files. The files contain test data from running the same test repeatedly on 8 test units, 5 times in a row. I expect to repeat this testing many times in the future, and so I am trying to speed up the data extraction time versus cutting and pasting. Once the data is...

Hi all. I use the code below to add missing numbers in a sequence. It works well, but if there is a letter with a number, it fails EG: 1 2 2A 3 5 Sub Add_In_Sequence() Dim LastRow As Long Dim gap As Long Dim i As Long, ii As Long Application.Screenupdating = False With...

In my Userform I have this code that when you put the customer number in and it populates the textBoxes with the customer info. I have a few customers that have a dash at the end such as 45610-2. It will not let me add a hyphen (dash). Is there a way I can use the dash on the userfom? Thank you...

Hi All, I've got a piece of VBA that I've developed that works perfectly fine apart from being slow why has to work on a lot of data at once. I know there will be a way to tidy this up and make it smaller however its out of my skill range at the moment. I would greatly appreciate anyone who...

In the following macro a value shows in cell A61 when theworkbook opens and remains until line “Cells(D + 1,"A").Value = intPrice” is executed. It then disappears so no value isassigned to intPrice. Can anybody help with this problem? Thanks in advance forany assistance. Sub Macro3() Dim symBol...

Hi Guys, Could you assist me with the below please, I want to just copy rows A:F when column A contains the word SSN. at the moment it copys the entire row, cannot figure this one out. Private Sub Workbook_Open2() Dim i, LastRow LastRow = Sheets("Sheet1").Range("A" &...

I have question on this, please. Please guide, what can be the solution.. I have some preposition's in my sentence..which are.. and, at, is, for, of, or I want to keep them in small letter and rest other text in proper case... I am showing my code.. '*Text Formating Proper, LowerCase...

Hi, Thanks for looking. Have been puzzling over this for an hour now but cannot piece in the missing part to the below. All I want to do is... - Define a range starting in cell A3 - Compare the value in column A with cell Q2, greater than or equal to and compare to cell S2 less than or equal...

Hi there. I am trying to delete any rows that have specific texts such as "car", "labor", "bat" for one of the sheet say sheet2 but my macro doesn't seem to work right. appreciate your help. Sub deleterow() For i = last To 1 Step -1 If (Cells(i, "A").Value) = "Labor" Then...

Hello All, I have this script for moving data from a userform to a TABLE on a sheet called Main. This is not working as the line "LR = Main.Cells(Rows.Count, "A").End(x1up).Row" keeps stopping. Can you have a look and let me know if you can see anything wrong. SideNote: I would also like a...

Hi , I am very new to VBA Coding .I am trying to write a macro to move the data across the sheets in a workbook . There are two sheets Active and Resignees. When I enter the ID in Resignees sheet (Cell D1 ) it should search the ID in Active sheet (Sheet having complete headcount details ) and...