excel macro

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

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

<!--[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/>...

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.

I'm not sure what I'm doing wrong when entering this code, but I did use it before and I'm not sure what I did the last time. Basically what i'm trying to do is to copy a range of columns and paste them into another set of columns. When I type the macro the error comes up for the first line...