excel vba

Hello All, New to this forum as well as VBA, so i would appreciate some insight. This is probably a simple fix, but i am not able to solve the issue. I have received the following error for the code in the module i am building. I have tried simple fixes ( adding and removing paste, changing...

I have data in A7-A26 and B7-B27. Column A is the new name for the sheet and column B is the sheet to copy. I would like to make a Macro that looks at the column B range, if there is the name of a sheet it makes a copy of it and renames it to the name in column A.

Hello, I have the following sheet that when the user saves it then copies to an email but it is cutting off the last few columns. The VB code I am using is as follows: Sub CreatePNG(Namesheet As String, nameRange As String, nameFile As String) 'ThisWorkbook.Activate...

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

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

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

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

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

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