excel vba

  1. R

    Highlighting cells based on criteria

    Hi, I'm trying to build an engine that does the following: There are 3 sections, all start in column J & end in column CC. Section 1 starts in row 11, column J and ends in row 83, column J. (73 rows long & 72 columns wide) Section 2 starts in row 89, column J & ends in row 161 column J (73...
  2. P

    VBA - Copy/Paste Value formula result in adjacent cell in row

    Hi - I'm not strong in VBA and haven't been able to find a similar thread with a helpful answer to get to my result. I have a spreadsheet with data in columns O through Z. When those columns are updated, a formula in column K updates to a new value. My desired outcome is that I'd like for...
  3. R

    VBA to update Actuals & Forecast

    Hi, Im trying to copy the formula from one cell to another as the date of the actual month changes. As the date changes to 31/5/24 in AD5, i want to copy the formula from Apr24 to May24 & do that for each of the 3 blocks shown. It seems simple enough code to do for 5-10 of these blocks, but...
  4. Z

    Excel VBA: Xlookup + Multi-Criteria + Copy to Windows Clipboard

    Hello, I'm trying to get a VBA macro to COPY a value to the Windows Clipboard based on two Criteria. I'm running a test using some sample data to match the Name and Library to a given Card number. What I'm working with so far... I've tested two different formula versions of using...
  5. G

    with Win32API, drag all open userforms, while dragging main userform.

    Using Win32API. Is it possible to drag all open userforms (shown or hidden) (all forms in VBA.userforms collection), when main userform is dragged, relative to Main Userform's position..? All the userforms gets initialized without title bar, and only main or first userform has dragging ability...
  6. C

    Duplicates with different data to combine with 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...
  7. Z

    Excel VBA: Using OR with <>

    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...
  8. R

    Excel VBA Plus Symbol Automatically Getting Added

    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...
  9. Y

    VBA to Script

    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...
  10. S

    Run time error 13 type mismatch

    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 <>...
  11. E

    Add row to table copying formatting

    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...
  12. M

    WorksheetFunction.CountIf with a range of values as criteria

    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...
  13. T

    Excel VBA - Send email in Outlook using 2nd account

    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...
  14. A

    Microsoft Excel VBA to : Find text from specific cell.

    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...
  15. S

    Formula or vba help needed

    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...
  16. D

    Excel macro to copy data from same column of different files within a folder to a single Excel

    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...
  17. arup1032

    VBA solution need to hide columns

    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...
  18. V

    Create sheets from templates selected according to unique cell data

    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...
  19. H

    Applying conditional formatting to all tables

    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...
  20. S

    Need to save workbooks in today's date folder

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top