vba

  1. G

    Still no solution after 1 Year - Please Help

    So the short version is: I have a tool that makes signs for items. The paper it prints on is divided into 8 signs. (8.5x11 Sheet) I have tried every different option to get it to print properly and I cannot. Each page should have 8 signs. I keep getting overlap or width issues. ("A1:BM99")...
  2. D

    Create empty table (with headings) in Word document after some text

    Hi guys, I hope this is the right forum for this question. I'm fairly competent in VBA in Excel, but recently started tinkering with creating letters in MS Word from our Excel VBA programmed management system. I work in Microsoft 365. I'm creating a Word document from scratch (out of Excel)...
  3. M

    Find Function VBA Named Argument Not Found-Runtime error 448

    I am writing a macro( late binding) that runs through a word document and highlight all the values that is contained in my cell range in Excel. I have used the find function which works fine until I add the argument IgnoreSpace:= True, which I don't understand why it's resulting in error...
  4. J

    Excel VBA .Save Causing a Save As to 'Random' number filename

    Hello, I have several VBA macros that have been working great for years. Recently I've been seeing problems when they call the .Save method. It seems to save the workbook but then also have some kind of catastrophic error where it tries to save the file as a random (only say random because I...
  5. C

    VBA: open and copy data from multiple (txt. files) to excel

    hi, need macro to open and copy data from multiple txt. files (exactly i need direct 35 values(years)) to excel. I did macro for one year, but im struggling to do it for 35 years, can someone help me with solution please? Sub txt_to_excel() Dim X As Double Dim TXT As String ' Adresss Open...
  6. S

    VBA : Allocate Data Randomly and Evenly

    Hello Good People, I have this allocation workbook that when I click a button. It will randomly divide the list of data into 8. (Currently 8 but it will soon increase). I have attached a sample images for my 2 sheets. Persons sheet - List of data Teams sheet - Output of allocation However...
  7. I

    Hopefully a simple find and replace VBA script

    I have the following data (before.png): I would like to have a VBA script which runs through column A looking for a carriage return. Upon finding one, it copies that entire row but only with everything PRIOR to the carriage return - it will make a new row for each iteration. It will then add a...
  8. S

    vba logic to open up several files within a folder and perform 2-3 steps

    Hello. I am trying to do the following. Within c:\123 folder. - i have 100 files. I need vba code to open up file 1, perform a few steps, remove a tab, rename a tab, autofit the columns, save and close, and then loop to the next file until file 100 is completed. I have the following code which...
  9. outlawspeeder

    VBA Is there an easy way to recreate new pivot charts

    I building a way for a worker to paste 5k line of info, clean it of $^!$@#$^% and then build a pivot charts (more than one) I recorded making a Pivot chart. It names the the chart +a number. Mine as recorded is 4. If I use this code again I get an error. I tried make a variable and replacing...
  10. J

    Automatically setting filters based upon user selection criteria

    Hi, Note: I'm not a VB expert or even a beginner, so I may get the wording wrong so apologies and thanks in advance: Background: I have 2 x sheets, called: • Master: This is a front menu page that all users see that contains an image (4 Pillars) as per the example: • Each Pillar...
  11. N

    VBA Question

    Hello, I have posted my excel VBA code below, I made it so when I double clicked on cells AP6:AP85 the user would be prompted to choose "Fixed" or "Variable" to use in subroutine get_supplier_rate. But when a user picks Fixed or Variable it replaces the original numeric value that was in cells...
  12. J

    VBA to clear all date in columns A2 to AC in the destination file, then copy the data from the same columns from all files in a folder

    Hi, I am wanting to merge all the data from cells A to AC from all files in a folder into one worksheet. Row 1 has the headers on it, so it needs to start at row 2. Columns AD onwards are locked. I also dont want to have to dismiss any update popups etc. I would like the user to be able to...
  13. T

    UserForm Close Event Hangs

    Through use of multiple UserForms I open a 2nd workbook that I hide and then may get or write data to that workbook before closing it. All was good until I noticed that when the red X in upper right corner (Close event) of forms was clicked that the 2nd workbook was left open and hidden. To...
  14. C

    Copy and paste data through multiple workbooks

    Hi, I am looking for a VBA code to look through Multiple workbooks in a folder, look through a column, match to an inputted Date/Value then past the whole row where this matched date is into a Master book. I currently have this only for a single workbook and it works but I keep getting an...
  15. Worf

    TypeScript, VBA, and the Graham Scan

    Typescript is the language of Excel scripts, available at certain Office 365 licenses. Unfortunately, my company chose to disable this feature, so at this time I cannot use it. However, we can write TS outside of Excel. This article shows how to output TS data to a text file that Excel can read...
  16. H

    How to login with username and password via Microsoft Edge in VBA code

    I'm still pretty green when it comes to coding in VBA. I've tried multiple different strings of code to try and accomplish this - all of them have worked in terms of getting me to my desired site in Microsoft Edge, but I haven't gotten any further. I've only ever been able to successfully write...
  17. I

    Evenly auto assign based on availability and language

    I am trying to evenly assign work amongst employees based on their availability and language. Please help, thank you very much in advance.
  18. F

    VBA to take a field value from 1 worksheet and update that field value to another worksheet based on another cell value

    Hi, its a Friday afternoon and my brain wont work at all. I have 2 worksheets. In one worksheet "Worksheet1" I have a defined table with 2500 rows of data with 2 fields, "ID", "Name" and "Amount". the values in the first "ID" column are unique and the "Amount" column is blank with nothing in it...
  19. Z

    Could you please help me about the vba code?

    I tried many times to write the vba code for below process but it didn’t worked. Could anyone please help me? Start from sheet 2 1) filter to show dates that before today+2 in column AI 2) filter to show blanks cell in column A 3) Do the same with next sheet 4) pop up massage Done once its done...
  20. Q

    How to stop InputBox from looping after input?

    Hi there! I am using this macro to sort through a master inventory list and transfer a row if the inputted "Vendor" is found when the InputBox populates. However, after the input, the InputBox keeps popping up and infinitely looping. How do I make it so that once a vendor name is entered, the...

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