excel macro

  1. D

    How do I get Excel VBA (with Solver) to choose the best value

    Good morning/afternoon! So I have a little problem. I have a large data set shown below: And the following fields, where "Drilled Hole Volume" and ""Volume of Bolt" remain unchanged and static. The only field changing here is the "Volume of Cartridge". Basically I'd like some sort of VBA code...
  2. J

    Searching for a country in address data, but right to left

    Hi, I'm using a macro helpully provided by hiker95 on a previous thread some years ago, but could do with a bit of help please: It looks through col A which contains raw e-com generated address data held in one string. It uses a list of countries in col C to find matches and adds the country...
  3. G

    Excel VBA:Paste multiple times

    Hi All, I am new to Excel Macro and to this forum. I am trying to write a macro to copy a range multiple times. Please correct me if I am wrong. Sub Macro1() Dim x As String Dim x1 As String Dim x2 As String Dim p, q As Integer Range("A1").Activate p = 1...
  4. N

    Post answers in a batch to MS Forms through excel Macro

    I currently have a form in MS Forms, and I will soon have an excel spreadsheet with a lot of answers to the questions I have in the form. I was wondering if its possible to make a macro that reads all columns in a line and posts the answers to specific questions in the MS Form? Please let me...
  5. B

    Excel Macro - Save as PDF

    Hello, I have been looking around for a macro that will save an excel sheet as a PDF with the following requirements: Named the same as the sheet Add current date select folder location I have been messing around with the following code: Sub Save_ActSht_as_Pdf() ' Saves active sheet as PDF...
  6. B

    Macro for Excel Data Consolidation

    Can someone help me with creating excel macro for the following. Data will be entered in the "Main" Worksheet Table. Shown entries for a project with two units - Unit 1 and 2. this could be multiple units. <tbody> Project Name "Enter Project Name Here" Test Date "Enter Test Date here"...
  7. A

    Swapping Named Cell Ranges Using Drop Down List

    I have searched all through google and cannot seem to find vba code to get me to what Im trying to accomplish. I have named the following groups of columns by going to Fomulas, then Define Name. Columns V:AB are named "Position_1" Columns AC:AI are named as "Position_2" Columns AJ:AP are named...
  8. E

    VBA Code to add a value from one cell to the contents of another cell

    I need vba code which will go to a certain cell that contains a groub of summation numbers and add another number from another cell ( value or formula) to them. So, for example: In cell "A1", "10" ( result from ("D1"+"G1") I need to add it to "B1" wich contain "=7+8+9" to become "=7+8+9+10", the...
  9. M

    SharePoint Online Excel File Opens as Read Only using VBA

    I am writing a macro to open and update an Excel file in SharePoint online using Excel in Office 365. I can open the file but it open as read only. I found the solution to add ActiveWorbook.LockServerFile after opening the file but I get application-defined or object-defined error when I...
  10. A

    Getting Error message on Macro

    Hi, I am getting an undefined sub error message on this macro I modified. I am guessing its something very simple I did causing the problem. The macro is to copy and paste from one spreadsheet to another 2 different ranges ( offsetting Journal entries). The original code was to copy from one...
  11. Y

    macro to send user to another sheet in document if checkbock is ticked, but do nothing if unticked

    I Team, I need help with code for an excel macro, which sends users to another sheet in an excel table once a checkbox is checked, but does nothing if it is unchecked. I tried this already, but no luck: <code>Sub CheckBox28_Click() If OptionButton1 = True Then...
  12. A

    VBA Macro code questions

    Hi all, I found a code to loop through the columns of a pivot table and identify the Columns that add to zero and hide them, but the code is stopping before it completes. The code is stopping at LastCol = Cells(GrTotLR, Columns.Count).End(xlToLeft).Column and I am not sure why. Also is there...
  13. N

    Auto spell check VBA macro in Excel

    Hello MrExcel, I need to write a macro which will auto spell check as we write in the Excel (Dynamic spell check just like in Word). I know that we have this feature in latest versions of Excel , but we are currently using a older version and hence to customize the feature. Please do let me...
  14. Z

    Macros for building PPTX from Excel

    Hi, I have excel workbook that has 6 worksheets. and these sheets (tabs) are dynamic that can be changed if I change a specific cell (this cell has all several locations). Since I have more than 60 locations, I need a macro that can: - Build presentations for each location whenever I change...
  15. M

    lock / protect excel macros

    Hi all, I am having an excel file which contains certain macros. I have locked / password protected vba project for viewing. This file will be used by certain users. I want to restrict circulation of this file. I want that only those users whom i permit / authorize should use this...
  16. E

    VBA code for going to the First Worksheet - Excel Mac 365

    Is there a Macro that can be made to go to the first worksheet in an excel file - regardless of the name of the worksheet I am not a programmer and do not understand anything about Visual Basics. I was hoping to find some VBA Code that I can paste into the VBA Editor in order to do this.
  17. L

    Small change to my macro

    I have a macro that I’m looking to make a small change to what cells get deleted after a copy and paste takes place. If someone could kindly assist. What I need to happen is as follows: Once a found number is entered in cell A1 (8 in this case) and is found in the cell range A20:A34 (cell B34)...
  18. S

    Multiple Filters + Filter Data by Year, Then Copy and Paste Data into new sheet

    I have a set of data, Row 1-8 has information on when the report was pulled out. So my actual data starts at Row 9 onward, from Column A to Column P I have successfully applied filters for field 7 and field 12 as these were texts. However, Column I consists of dates (in d/m/yyyy h:mm format)...
  19. G

    Automated PDG Report from Chart Data

    <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...
  20. R

    Macro to copy/paste item from list

    I have a list of names in Range A20:A55. Starting from Cell A20, I want to invoke a macro to copy current cell on the list to location "C3" then return to list and move down 1row to next item on the list. Then calculate and stop. Will repeat the macro from each item on the list, then calc and stop.

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