code editing

  1. A

    Pivot Table Macro only works for one workbook! How to make it applicable to all? Code posted

    Sub Macro1() ' ' Macro1 Macro ' DataSheet ' Creat Standing Data Pivot ' ' Keyboard Shortcut: Ctrl+Shift+Q ' DataSheet ActiveSheet.Name Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Sheets.Add NewSheet ActiveSheet.Name...
  2. M

    How to compare changing dates in VBA

    I am very new to VBA and am teaching myself as I go. The one thing I need but cannot figure out is: I have a spreadsheet. Each day user fills out a userform to input data as needed (around 50 inputs). The code once the user clicks "Submit" on the userform takes all of that data and places it...
  3. K

    How to split the last row of cells in one sheet and copy to another sheet's specific location?

    I have reviewed several similar topics and there is something I am definitely doing wrong. I have a worksheet called "ShipDtls" that contains data. I want the last row, columns 16 thru 20, data split (see link w/example: ) {link...
  4. B

    excel 2013, vba mutiple column Filtering Automatically On Cell Entry

    hi dears, i am using excel 2013 i try to make a traceability for our product manufacturing and delivery MY FORMAT IS (1 - 24 COULMNS) A1PROD DATE A2CLIENT A3WO A4ITEM A5DIA A6QTY (M/Nos) A7ID Nos A8LENGTH (M) A9MATRL A10PR in BAR A11REMASRKS1 A12STIFFNESS A13PROD A14CLBRTN A15QC A16DLVRY...
  5. sashapixie

    Turn a fixed range in VBA code to a dynamic range in VBA code

    I have the code below to input check boxes and link them to the cells they are located in, I want to change to the range to a dynamic range for e.g If cell B3 <> "" input check boxes in to columns J3:R3 and also I want to align the check boxes to be in the centre of the cells. Option Explicit...
  6. pedie

    Could someone please edit this code for me? Thank for helping!

    Hi, I am running this code from book1. trying to copy from book1 and then paste it in book2. Macro3 is to simply copy from region "A3 to F3" I am getting Runtime error '9' subcript out of range Please help! I understand, I think you guys must be tired of my thread but I would request...

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