excel vba

Hello all, Once again, I find myself seeking help... (Glad this forum is here!!!) I have a spreadsheet with 21 columns with various data. Column 1 is a part number, column 3 is a product type and column 6 is a date range The problem is this...there can be anywhere from 2 to 7 lines with the...

Hello, I'm wondering if it's possible to use the OR statement with Not Equal To (<>) in VBA. I'm trying to simplify the user selection from a MsgBox to validate the entries and then Exit Sub if no valid matches were found, Else proceed with running the Macro. Here's what I'm working with...

Hi Friends, I wrote a simple single-line coding to bring the C2 value to D2 in Excel VBA. ThisWorkbook.Sheets("MM_Input").Range("D2:D2") = "=C2" After I executed the above code I noticed a weird result in cell D2 like the one below, I do not understand why the plus symbol automatically gets...

Yea, I have no idea where to start. I have been all over google trying to figure out the structure. I have a VBA that i need to put into a script inorder to use it in AppSheet. Can you point me in the right direction? Sub ResetWeekly() End Sub Sub ClearOldDates() 'Declare variables Dim rng As...

Hello all, I have problem with VBA macro in excel. I see error 13 type mismatch, after try to import data to excel sheet. First macro import data from several files from the specified folder (*.xls excel files), but it stop with error at: "If Target.Column = 1 And Target.Row > 1 And Target <>...

Hi, Very grateful for anyone's help or advice! I have a table called "CR_Table" - I'm looking to add some VBA code to insert a row to the bottom of the table when I click on a button, copying the formatting/ formula from above. Please could anyone let me know what code would help me do this...

Hi! I've been dealing with a problem which I can not find information about it. So what I want to make is a count of records depending on a criteria, I know I can accomplish it with WorksheetFunction.CountIf but let me explain a bit further. The problem I face is giving the criteria argument as...

Hello, I'm new to VBA. I have a working macro below to send Outlook mail using Excel VBA: Sub Use_2nd_Account() Dim outlook As outlook.Application Dim outlookmail As outlook.mailItem Set outlook = New outlook.Application Set outlookmail = outlook.CreateItem(olMailItem) With outlookmail...

Hello, my name is Andrian I would like to have a Search Macro box to click to find text from specific cell. I had a macro just to find the text. (CTRL + F) it works just fine, but i need to have the macro highlight the text/cell from the text found from searching the text. because workers here...

I have 2 sheets called CON, COM based on the values in column q in COM for each unique value a sheet is created in the same workbook. In the new sheets I have in R2 opening Bal. the value of opening bal needs to be taken from sheet CON. There is a date to be considered as well. Along with the...

Hi Everyone, I have a folder containing thousands of files with similar data from sensor. (1 machine cycle will generate 1 csv file.) The sensor data is stored in column B in every files. I would like to copy all the column B data to a single file to do analysis. The first thing when running...

I have an Excel sheet where columns A and B need to be visible always. I have some range C to O Q to AC AE to AQ AS TO BE BG TO BS BU TO CG CI TO CU CW TO DI DK TO DW DY TO EK EM TO EY FA TO FM FO TO GA GC TO GO GQ TO HC HE TO HQ HS TO IE IG TO IS IU TO JG JI TO JU i need When I will select...

Hello, Can anyone help in cranking out the VBA code I have a "Master" sheet with 2 columns : "TYPE" and "NAME" and I have a command button (ActiveX Controls) created and named it "CREATE SHEET" And, I have 2 other sheets namely "TEMPLATE A" & "TEMPLATE B". What I would like to do is: EXAMPLE...

Hi everyone, I’m new to this forum / VBA and I’m trying to create a code that applies conditional formatting for all columns in every pivot table and refreshes every table in my Excel workbook. I’ve been able to set this up for one pivot table / one sheet but I’m not sure how to change my code...

Good Morning, Everyone is doing well !! Though I am still in the learning phase and in past years learned so much from Forums and Youtube videos. Need help with the below code where I have successfully saved the files in a folder by giving them a location and the location we need to put in...

Hi, I need support for knowing the problem in the below code as the error message "Run-Time Error '13':type mismatched" appeared Sub SendAllDraftEmails() 'Declare variables Dim objOutlook As Outlook.Application Dim objFolder As Outlook.MAPIFolder Dim objMail As Outlook.MailItem Dim lCounter...

quiero pasar una base de datos de excel a powerpoint pero cada vez que se genera el archivo se crea en las mismas diapositivas , quiero que se haga en el orden de la base de datos en la misma diapostiva Opción explícita Sub Combina Correspondencia() Dim strBaseDatos como hoja de...

While import file will have many row maybe more than 5000 row, so I want to cut 1-100 row to in 1 excel and then 101-201 loop file until to 5000 row. Sub test() Sheet60.Range("A1:BX100").Copy Workbooks.Add Application.DisplayAlerts = False ActiveSheet.Paste Destination:=Range("A1")...

Here is my code, first off: Sub namelookup() SalesForm.BHSDTAPNAMELF.Value = Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("NICK TAPS").Range("S:S"), Worksheets("NICK TAPS").Range("T:T"), Application.XLookup(Val(SalesForm.BHSDMAINNUMBERLF.Value), Worksheets("CB...

I have a workbook with 2 worksheets, one named "Timesheet" and the other named "Data". I created a button on the "Timesheet" worksheet (Add Work) that will insert a blank row on the row directly above the button. Row 2 on the "Data" worksheet has code in some of the cells and I want to...