vba & excel

  1. M

    Is it possible to run macros from multiple files?

    Long story short. we have about 10 teams that were running a template that had macros embedded in the files. I'm trying to see if its possible... if i had a list of the 10 file locations, go down that list, open the file and then run said macros associated with each opened file. before I dig...
  2. D

    Excel VBA: For Each ws loop doesn't work as expected

    Hi, new to this forum, hope you guys can help me with my issue altho my expressions are terrible :') I have attached a picture of how my excel looks like and my code below. Basically what it's supposed to do is to extract files from different locations and combine them as separate worksheets in...
  3. B

    Warning message with VBA when opening file

    Hi guys. I'm a noob working with VBA, so I need your help. So, I have an excel file, where I have a table with some data. In this table, I have a collumn named "expiration date" (column G), but not all rows have expiration dates, some of them are empty. I have setup a conditional formating...
  4. I

    Excel VBA macro to add a new row every 20th row from A2 not A1

    have a code that misses row A1 and then adds 20 rows after this. I need the code to add 20 rows after A2 Sub AddRows() ScreenUpdating = False With ActiveSheet lastRow = .Cells(.Rows.Count, "A").End(xlUp).Row End With Dim AddRows As Integer: AddRows = 20 Dim i As Integer: i = lastRow Do While i...
  5. Z

    Excel VBA - Fill data in a Range based on value that has been picked from another search

    Hello, I am after a VBA code that will fill in data for the 'Location' Column. The value of this data to be filled in will pick from the 'Manufacturing method' offset value. If the 'Location' value is blank I want to search the 'Manufacturing method' column to find the value 'Assembled-House'...
  6. M

    Can some one help to write a piece of vba code

    I am new to VBA and would need help to write a piece of code for the requirements below: i have a spreadsheet with 1000's of data From the data in the column “N”, for each line: Copy-paste all the objects starting with “L-“ into a new column named “Location Type” Copy-paste all the objects...
  7. C

    Need help setting up multiple sheets as source worksheets. Trying to loop through multiple sheets to consolidate data into a master sheet

    Hi! I am new to VBA. I currently have this code to help bring in data to a master sheet from another sheet with the same column header. Right now it only looks at one sheet (v6d). How do i get the code to look at the other 4 source worksheets to bring back the data into the master sheet? Code...
  8. S

    I want to save activated worksheet(here name is template) at given folder path and want to save in tab with specific worksheet name using VBA macro

    I want to save activated worksheet i.e.template at given folder path and want to save in tab with specific worksheet name using VBA macro and want to delete activated worksheet(template) again.as i am doing this for number of files and also i want to add wrap text =true and row height set 12.75...
  9. T

    VBA – Copy rows to a new workbook based on a cell value

    Hi I'm new to VBA, still learning the ropes. Please can I get some assistance and would appreciate help with the below code. The macro runs but copies the same row of data to row 3 in the destination workbook (TEST1), instead of copying it to the next row based on the last row that contains...
  10. B

    listview in a VBA Userform object required error 424

    Hi everyone, I have a problem with listview. I want a table with some informations in my sheets when i click in a button "CommandButton1" but i have an error 424 object required here : Someone know what is my problem ? Thanks by advance here is my code : Private Sub CommandButton1_Click()...
  11. E

    Slicer not working on Chart in VBA, but works after selecting chart data manually

    I created a VBA script that adds charts and slicers to my worksheet, but for some reason they don't work after adding them. Now, once the charts and slicers are added I would go and select on the chart, right click and click "select data" then click ok. Once I do that the slicers work with the...
  12. L

    ActiveX CommandButton becomes non-clickable after making it invisible and visible

    Hi guys, I encounter with a problem that Commandbutton works well before hiding it. But once making it hidden and back, the button suddenly does not react to click_event anymore. I have to close the excel and reopent it, then it recovers. I just have searched the problem. There are similar...
  13. P

    Share excel file containing live quotes from Bloomberg

    Hi everybody, I am Paul, and I recently joined that forum. I would like to share to other computers an excel file which contains formulas to fetch live quotes from Bloomberg. My idea was actually to push to OneDrive or Sharepoint a copy containing only values and being updated with a Macro...
  14. S

    Need help on Insert PDF file VBA function

    Dear Members, I am using the following code to display photo from a folder in my excel sheet. Sub DisplayMainPicture() With Sheet1 On Error Resume Next .Shapes("ReceiptPic").Delete On Error GoTo 0 If .Range("I12").Value = Empty Then Exit Sub PicPath = .Range("I12").Value 'Picture Path If...
  15. F

    Extract specific lines from a TXT file to an Excel Sheet

    Dear all, I am being new to VBA (learned about the existance of VBA 2 weeks ago), and I have a question about the extraction of data from a txt file. I have a code that extracts the data of a txt file to my excel sheet, and I wanted to know about the existence of a formula that could only...
  16. 1

    Inserting new rows based on cell value and copying data to the new rows

    Hi all, I've been searching for a solution to my issue on the board but could not find a working solution that covers my needs. I'd really appreciate some help to come up with a VBA code that does the following: I need to break down a single row of data consisting of multiple columns into...
  17. S

    Can you help me solve these challenges in the search code in the list box?

    This code works fine in the listbox, But when you try two scenarios, the following happens: 1) when replacing a line (myCols = Array(1, 3,4, 5, 7, 10) with TextBox and let TextBox 2 written inside it (1,3,4,5,7,10) it gives me an error message (application defined or object defined error...
  18. M

    How to run macro automatically between specific time range daily

    1. I open my PC at 7 AM 2. I want to run my macro (Org90) at 9 AM 3. Then I want my macro (Org90) to run every 1 hour 4. At last I want my macro to stop working at 5 PM automatically daily. I searched all internet that I can, but I didn't get a full answer to my question. I know it is...
  19. T

    looping vba vlookup column index number

    hey,hope you are doing great, the below code matches the first column between 2 workbooks then copy & paste the matched results using vlookup function, the problem is that vlookup only shows 1 cell result while i need the whole row to be copied so i tried to loop the process to chnage column...
  20. N

    How to link to subfolder with current VBA Macro

    Hi, I have the current code that works to pull directly from a shared folder's inbox. I need it to pull from the SubFolder "Shared Email box" > Inbox >>"SubFolder". Can you please tell me how i can modify the below? Sub GetEmails() 'Add Tools->References->"Microsoft Outlook...

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