excel vba

  1. C

    Comparing Cells

    I have a large workbook and the data within in needs to be filtered, I have datestamps in column A, these then need to be checked over all of coulmn A to see if there are any duplicates, if there are that duplicate then needs to be check against a value in column D, coulmn D contains a value...
  2. C

    Lots of help Please

    Hi all, I am Currently working on a VBA that is able to open lots of workbooks from within a folder, each of these workbooks only has 1 work sheet, this work sheet will have multiple columns and 1000s of rows. I have an identifier in Row R that I use to separate the data. I then want excel to...
  3. M

    Macro Fit a image in a cell acording to his size.

    As this is my first message here and I don't see any place to make it, i Want to say Hello word and thanks for the amazing job all you are doing for teaching us. I have a question with a macro that works well, but I can't adapt it to improve what I want. I have a book that the first sheet is...
  4. R

    Excel VBA - Loop copy data from X input workbooks and saving X output workbooks

    Hi guys, Very new to writing macros, I'm trying to automate the copy/paste/save of input and output data but I keep locking myself out of my Calculations workbook in the process :cry:! Context: I have the parent folder directory "...\Macro Test\" which contains 2 folders "Input" and "Output" and...
  5. K

    I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code....

    I was make Print to PDF With Duplex page , its Work , But How to set (Top, bottom, Left, Right Margin) in this VBA code.... i was Create MODULE and put this VBA code , So Amazing Trick to ,make Print TO PDF with Duplex (Both-side),,,,, Kindly Provide set VBA code For both page Margin...
  6. M

    Help on a Old thread that I cant find a resolution to.

    I am on office 2019 and I have been trying to automate my emails to an excel sheet as part of a Ticket System, I know absolutely zero VBA and have just been trying to cobble something together off of some old posts. All the different vba code I have tried keeps creating a copy of my workbook...
  7. P

    Encountering Runtime Error When Entering Date in Textbox

    I have the following code that upon exit from Textbox87 first checks to make sure the user input a date in the correct format and that it is a valid date. Then it checks to see if it is a past date or a future date. I receive a Runtime Error 13 Type Mismatch error only if a nonsensical date...
  8. C

    [VBA]USE Mobile Data Collection - Scan-IT to Office SCAN BARCODE &INPUT TEXTBOX

    I used the Excel"Scan-IT to Office app" to scan barcode . When I use my phone scan barcode,it always input to A1 cell or A2 cell...>A3>A4>A5..... I need the "barcode number" input to the userform "textbox(A)" not "sheets's cell(A1)" Like the picture I need the "barcode number(60106-04...
  9. EX_CELL_DZ

    [ VBA ] NoSuchElementError | Help !

    I want to automate a website but every time I received this error. and the website does not load completely and it redirects directly to Google Sub Amatti() Dim GC As New WebDriver GC.Start "chrome", "" GC.Get "Request Rejected" GC.Wait ("10")...
  10. A

    There isn't enough memory to complete this action

    Hi all, When i press a button to run the VBA, previously it works but now shows the below message but my excel version is Microsoft 365. The VBA show error on here but i don't know why, would anyone help me? Thank you very much Below is my code: Dim wb As Workbook Dim wb2 As Workbook Dim...
  11. B

    Excel VBA Userform: Filtering a Listbox and Showing a "Live" Version of the Filtered Data Based on a Texbox Value

    I have a "Data" worksheet that I want users to be able to edit the data in this worksheet by using a Form (keep the data uniform). When the user opens the initial form (UserForm1), this will display all of the rows of data that they can select from to edit. Because this data set is large (will...
  12. I

    Automate SAP Theme setting by Excel VBA

    Hi........I try to automate the SAP theme setting by using Excel VBA. My requirement is “If Selected theme not equal to " Corbu Theme" then change the selected theme to " Corbu” This is the code to load the SAP GUI Options >>>Shell "C:\Program Files...
  13. M

    Making text bold using wdDoc.Content

    HI, I am a rookie VBA coder, I use it to automate work for myself :-) I have this piece of code that is part of a larger routine, all works but I would like to make some text bold and underlined and some normal. With wdDoc.Content '--- paste the range image first, because it...
  14. P

    Email list on Excell with template but missing Signature

    good afternoon all, I've been tasked to contact over 500 companies my work deals with on a regular basis and need updated details from, I have collated an email sheet and have used the following code to produce the emails to each company, as I didn't want to fill out an additional column on...
  15. J

    How to speed up the for - next statement using always the last 200 rows that contains text of a column

    Hi, in order to speed up my attached code, I would like to loop (for - next) only the last 200 rows instead to loop all the ranges AA:AA and L:L. How could I do that? Please, note that the data from Production data.xlsm is increasing every day and the code selects the ranges with an "X" in...
  16. B

    Error handling advice for webscrapping

    Hello I need some help with the code below, Sometimes the page does not login, sometimes the iframe does not load, I am looking for a way to handle this error and attempt again and not resume, if not then exit and login in again. In bold are the areas where sometimes it crashes. Any help or...
  17. An Quala

    Delete the empty sheets from a created file

    Hello, I use the following code to make a new file after deleting the certain columns from the old file, but I want to add one more thing here, if any of the three sheets ('Sponsored Products Campaigns', 'Sponsored Brands Campaigns' ,'Sponsored Display Campaigns') are empty (i.e. A2 is empty)...
  18. 2

    Excel VBA: after filter use, select resulting cell

    Happy Friday, On a spreadsheet, using a filter in a header row manually Top rows, including header are frozen After selecting an item from the filter list and clicking OK, Excel does not select the cell to which it just filtered How do I get XL to select the cell to which it just filtered...
  19. C

    Running VBA Code from Excel to delete a Rich Text Format from a Word Document Dependent on A Dropdown Box in Excel

    Hi all, I am working on a project that uses a form I have created in Excel to populate Rich Text Formats in a word document in order to streamline report generations. I have almost completed the project but I have ran into a problem I can't seem to figure out. I am fairly new to the VBA...
  20. Richard1982

    Excel/VBA automatically opening file - can I avoid this?

    I have a small section of VBA code (as part of a larger macro) which takes some of the pages of the report I'm working on and saves them to a new file. Dim wb As Workbook Set wb = Workbooks.Add ThisWorkbook.Worksheets(Array("Page 1", "Page 3", "Page 4", "Page 6", "Page 7")).Copy...

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