vab

  1. A

    How remove the Last 5 character throu VBA

    Hi Folks I need small macros removeing Last 5 character of the Word In Exp: AT_1833 I need AT only. Removring _1833
  2. H

    User Form Date picker Calculation

    Hello, Having trouble with a user form I am building. What I am trying to accomplish is a calculation to auto show in textbox1 the number of days between today and what is entered in datepicker1 - even when datepicker 1 is at default of today. Thank you,
  3. A

    How to Create a Login Window to Protect Excel Workbook and recorde login

    Hi folks, Thank you for you support. I have search in google i find below from this sit(https://www.datanumen.com/blogs/create-login-window-protect-excel-workbook/) but it not suitable for me. Because of have 30 users and this code very long and user login not recode so. Please help me this...
  4. A

    How To Save File With User Enter path with Input BOX

    Hello Every one Dim T as Variant T = InputBox("Enter Your CORP ID") ChDir "\\Client\C$\Users\T\Desktop" ActiveWorkbook.SaveAs Filename:= _ "\\Client\C$\Users\T\Desktop\From Application to MIS_V.0.1.xlsm", _ FileFormat:=xlOpenXMLWorkbookMacroEnabled...
  5. K

    how to find duplicate rows?

    hello , how to find duplicate rows and then copy and paste to a separate sheet, it must match the entire row contents. below are sample data: from A to Q column, total 2047 rows including heading. <tbody> 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 0 0...
  6. M

    copy data and not formula

    Hello, I have a document containing 3 sheets. sheet 1 pulls data from an external source sheet 2 uses index and match to locate and copy errors sheet 3 will record errors collected by sheet 2 sheet 2 is using index/match formulas to locate information there is 100 rows with the index/match...
  7. P

    VBA: Serach column for date, cut then paste row into new sheet

    Could some kind soul please advise me on VBA coding to complete the following; Search the Completed column (G) of the ToDo List worksheet for any date entries. If any entry found to cut and paste the entire row(s) onto the Archive worksheet (Ensuring they are pasted into the next free row)...
  8. W

    VBA for Value sign change

    I'm dealing with a dataset that has columns that should be negative values, often those values are pasted from a source file which has them as positive numbers, thus far I am doing a paste special with the mutiply operation having copied a "-1" to the clipboard. I'd really like to avoid the few...
  9. G

    Turn on cell lock if conditional format rule is true

    Dear All, I am trying to create a macro that will set the Lock check box to True for a cell if Conditional Formatting rule #1 for that cell is True. I borrowed some code and ended up with the following that does not work correctly. This code never results in a True. I don't understand...
  10. A

    Help with Defining a custom funtion in VBA

    I would like to create a custom function that would convert a date in format mmddyyyy into a string with the format yyyymmdd. Here is an example 04/03/2009 (April 3rd 2009) ---> 20090403 I have the following code so far, but the only thing it returns is "0" <link rel="File-List"...

Watch MrExcel Video

This Week's Hot Topics

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
Top