1. N

    How to open one workbook find a max value in one worksheet and return it from a function

    Full disclaimer I have only been using VBA for very small projects and have never attempted working with multiple workbooks. I have a user form in 365 that enters data per the form's request. I am using 3 files, an entry file, a database file, and a read file. Between the database file and...
  2. S


    Hey All, Windows Office 365 (Excel Version 2306) I have taken over maintaining a global macro file that is stored in XLSTART so everyone in the office shares the same macros for every single excel sheet opened. I want to be able to detect when a new xlsx/xlsm file is opened and record the...
  3. J

    Take Excel Worksheet, Divide into Worksheets/Workbooks by Employee/Card #, Email via Gmail to Employee for Input

    Apologies if this is completely basic, but I can't find anything in the forums that directly relates to what I'm trying to accomplish. I am not at all schooled in anything VBA, technical Excel, etc. I just Google to figure things out, and here I am! Here's my starting point: I have a workbook...
  4. brendalpzm

    Copy worksheet into a new workbook

    Let's say I have 2 workbooks and i have to create 1 wb1 = workbook with the macro wb2 = worbook with the info so I have an activeX button in wb1, when I click it it should copy the KeySheet from wb2, create a new workbook (wb3) and paste the sheet onto this new workbook Idk if i explained...
  5. I

    Copy sheet from active/open workbook to other closed workbook.

    Hello All...please someone help a VBA code that can automate copy of sheet from open workbook and paste to other but closed workbook. Then overwrite if sheet name exist. Example as follows: Open File1 = main file, have the sheet name "report". Consist macro that copy the sheet name "report" to...
  6. B

    How to make my worksheets into workbooks in a designated folder?

    Hi people, The code I currently have is fully functionning, however I would like to add a feature that takes each worksheet that starts with MW and makes it into a workbook that is then saved on a folder that I've made ( the path is C:\Users\(MYNAME)\Desktop\VBAWorkbookTest). Ideally, the...
  7. kelly mort

    How to detect workbook New openings (vba)

    π™·πšŽπš•πš•πš˜ πš πš˜πš›πš•πš π™΅πš˜πš› πšŽπšŽπš‘πšŠπš–πš™πš•πšŽ, πš’πš— 𝚊𝚌𝚌𝚎𝚜𝚜 𝚒𝚘𝚞 πšŒπšŠπš— πš˜πš™πšŽπš— πš“πšžπšœπš πš˜πš—πšŽ πšπš’πš•πšŽ 𝚊𝚝 𝚊 πšπš’πš–πšŽ. 𝙸 πšŠπš– πšπš›πš’πš’πš—πš 𝚝𝚘 πšŠπšŠπšŒπš‘πš’πšŽπšŸπšŽ πšπš‘πšŠπš πš’πš— πšŽπš‘πšŒπšŽπš•. 𝚜𝚘 πš πš‘πšŽπš— πš’ πšŠπš– πš˜πš™πšŽπš—πš’πš—πš πš–πš’ πšπš’πš•πšŽ πš’ πšŒπšŠπš— πšŒπš˜πšžπš—πš πšπš‘πšŽ πš—πš—πšžπš–πš‹πšŽπš› 𝚘𝚏 πš˜πš™πšŽπš—πšŽπš πš πš˜πš›πš”πš‹πš˜πš˜πš”πšœ πšπš‘πšŽπš— πšŒπš•πš˜πšœπšŽ πš–πš’ πšπš’πš•πšŽ πš˜πš› πš˜πšπš‘πšŽπš›πš πš’πšœπšŽ πšƒπš‘πšŽ πš˜πš—πš•πš’ πš’πšœπšœπšžπšŽ πš’ πš‘πšŠπšŸπšŽ πš—πš˜πš  πš’πšœ πš‘πš˜πš  𝚝𝚘 𝚍𝚎𝚝𝚎𝚌𝚝 that when I am trying to open...
  8. R

    Prevent changes to specific worksheet (VBA)

    Hi, I would like to disable the option to delete, move, copy or rename one specific worksheet in a workbook, regardless of the activated worksheet in the workbook. I cannot protect the workbook structure, because I want to still be able to delete other worksheets in this workbook without the use...
  9. R

    Copy error - range is cutting and pasting to wrong sheet

    My code below: Sub arrange() 'all declarations for wkshts and wbs stated at top unless stated here Dim g1 As Range Dim g2 As Range Dim g3 As Range Dim g4 As Range Dim g5 As Range Dim g6 As Range Dim g7 As Range Dim g8 As Range Dim g9 As Range Dim g10 As Range Dim g11 As Range Dim g12 As Range...
  10. T

    [VBA] Compare Two Sheets, Highlight Differences, But Consider Add/Remove Rows

    Hi, This is my second code in VBA, which will hopefully work; so consider me a beginner. I have two workbooks that I want to compare and highlight differences. I've prepared a VBA code but if any rows are added or deleted it marks them too, which goes against what I want to do. Aim: Every time...
  11. R

    Macro to add month sheets containing days

    Hi, I have a VBA code (see below) for a macro button to add month sheets in a workbook. Now the month sheets are sorted from January to December, but I would like them to be sorted from December to January; while still keeping differently named sheets at the end of the worksheet tabs. After...
  12. L

    VBA - Import range from other worksheet

    I'm new to VBA and I'm trying to move my first steps into it, I need help! Below you will find a code to import a range from a selected file to the active workbook. The macro is assigned to a button on the active workbook. What I miss, and I'm not able to write is that I would like to paste...
  13. E

    VBA - Generate Serial Number max in two sheets

    Hi guys, have serial numbers with data in row in two different sheets (from main sheet divided later to two different, according the data in row). can someone help with a code to generate serial number after checking what is the max in the whole workbook? i am currently using +1 on the last row...
  14. R

    List all conditional formatting rules in a workbook

    Hello, I have a situation where I am trying to list all conditional formatting rules that are in an entire workbook. In this forum I was able to find a thread that is over 3400 days old. Thread is titled "List all conditional formatting rules in a worksheet". In that thread, this is the VBA...
  15. R

    Copy all sheets to new workbook without formulas and macros

    Hi All, I want to copy my whole workbook (xlsm) with formulas and macros to a whole new excel file (xlsx) without any formula and macro. I've found the script below on internet and works fine but is for 1 certain sheet. How can i include multiple sheets and copy this to the new workbook? It is...
  16. A

    VBA macro to loop through all workbook > find keywords in cell > copy adjacent cell > paste it in a master file into respective header

    I have several workbook(.xlsx) that have only 1 sheet per workbook. I would like to loop through all the workbooks in the folder one by one and find certain cells with specific keywords and copy the cell adjacent to it. Next, copy all the cells and paste it in a master file into its respective...
  17. U

    VBA - Object 400 - After Selected File to do a Copy and Paste Vlookup

    Hello, I'm trying to Select a File with a static table with Allocation Data and then copy and paste the data in each workbook corresponding to the employee number after a vlookup of cell A2. The first block of If statements is a file selector which returns the file path. I believe I'm...
  18. Mackeral

    WORKBOOK_SAVEAS not working

    It fails with Error 1004. The original file name was "Data Entry.xlsm". After the failure, when you look at File Explorer, the file has been renamed and it's written date is appropriate. Is there something about a "Sync" going on here? Thanks for your help. Mac
  19. E

    How to stop Excel's "Save As" function from defaulting to Text (Tab) on XLS files?

    So whenever I attempt to save a fresh excel file, it will have my default save as option as XLSX. But I frequently have to download XLS files and then edit them. Whenever I finish I go to save as, and it tries to save it as a text (tab delim) file every single time. I have checked and confirmed...
  20. M

    Userform Hide Workbook

    Hello All, I have searched online for this issue but couldn't find a proper solution. I have a userform that open (while the workbook itself remains hidden) using the following code: ThisWorkbook.Windows(1).Visible = False If Workbooks.Count = 1 Then Application.Visible = False...

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