record macro

  1. Jyggalag

    Swap two values in a cell?

    Hi all, I currently have these values in a larger format from rows J - N. I have made a small example of my data here: I essentially want to swap my "." with my "," in every cell, if applicable. If not applicable, I want to replace my "." with a "," and my "." with a "," Does this make...
  2. Jyggalag

    How to use Vlookup with IF statement?

    Hi all, I am very rusty in Vlookup (embarassing!) and I am currently looking at this data: I would like to create a formula that checks the same date in column A, as checked in column F and then tells me whether or not the value for this date is also present in my data set in columns F-G. I...
  3. Jyggalag

    Text to columns issues

    Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...
  4. Jyggalag

    Macro not working

    Hi all, I have this macro that i recorded, and it produced this code: However, when I use it, it just erases everything in column E and does not paste the data from column F at all! please help me fix it`?? this is my setup, with the macro being called "update", as you can see, my cells...
  5. Jyggalag

    Create macro that copy paste's data

    Hi all, I am having a huge issue at the moment with some macros i created (through record macro). Basically, I have this excel sheet: I tried to record some macro's, where once I press unfreeze, they post this formula: =IF(ISBLANK(B9),"",TODAY()) for the left one...
  6. Jyggalag

    Change my email macro to email multiple recipients in different rows

    Hi all! I currently have this setup in Excel: And the code is this: Option Explicit Private Const FilePath As String = "\\COMPANY.MSAD.COMPANY.NET\userdata\t543932\home\Documents\TESTfolder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim...
  7. Jyggalag

    Create macro to separate first name and last name in email and plug it into columns

    Dear all, I am currently working on a spreadsheet that looks like this, albeit the real one is much larger: I was wondering if there would be some way in which I could create a macro or some VBA code attached to a macro where, once i press it, it takes the e-mails from C2-C12 and takes the...
  8. K

    Add record macro in existing code

    Hi, Is there a way to add in an existing VBA code a new macro but from record macro function?+ And if so, how? Thanks in advance:)
  9. A

    Make a cell do a spesific action

    Hello, i am new in the forum, i would like to ask how we can make a cell do a specific action. Example i am using Excel 2010 and have text in a cell i want to press the cell and this text to go automatically in the search of Thunderbird in a specific email's address inbox. If i am not...
  10. F

    recording macro question

    how can i make macro work on different sheets and different cells . example im going record macro then im going to change the color of cell A1 in sheet 1 then i will stop the macro then i will run the previous macro that i have recorded in sheet 2 but i want to change the color of different...
  11. Z

    Recording a Macro with a Validation List

    I have to prepare 70+ tables from a data set. In order to take the same information from the data set, I have created a validation list dropdown (in cell A2). The next step (that I need help with) is recording a macro that prints the first table, then selects the next item on the list and prints...
  12. B

    VBA "IF' statement

    I am currently working on a macro that will decode the cell above it with an "if" statement. There are around 60 different possibilities, so the statement is long. I typed the equation into a cell on excel. From there I recorded macro, and entered it into all the needed cells in the workbook...
  13. E

    copy + paste a merge cell

    hi there! i want to create a button that will COPY the cells "Sheet1!A1:D2" to "Sheet2!A1:E1"... i tried recording a macro with that but i always get a WARNING... can someone please help me with this, i dont want that warning to pop up again... plz...thanks :)
  14. Z

    Formula works but can't record

    Hi, My formula works when I type it in. However, when i try recording it "unable to record macro" appears. I read somewhere that excel doesn't record macros if the cell has more than 255 characters...
  15. M

    creating and formating charts in vba

    i want to write a code that generates data and add a chart. i tried recording a macro (subroutine) but i read that excl2007 has problems. so the x values go from 1-100 on column A and y=(2*x)+7 on column B. then from this data i want to add an xy scatter with smooth lines. then i want to format...
  16. D

    Error: Unable to set the Orientation property of the PivotField class

    I have Excel 2003. I have 2 different data fields being pulled into the area vol_net and vol_gross and for some reason when there is a lot of data the table freaks out and comes up with the orientation error. With ActiveSheet.PivotTables("PivotTable3").PivotFields("vol_net")...
  17. S

    Limitations of Macro Recording

    Hi everyone, Hopefully someone can help me with an issue I have with macro recording. I'd like to record a macro which: 1: copies the text string in a cell 2. filters a list based on that string 3. opens a pre-created workbook whose filename is based on the original string 4. copies the...
  18. C

    Recorded macro does not work?

    Hello, I came across a problem with my macro and decided to record a macro and see how excel did this, the result: Range("G14,I14").Select Range("I14").Activate ActiveSheet.Shapes.AddChart.Select however, when I run this macro i get the 1004 error on the last line?! The last...
  19. P

    Opening a .xls file in XP also opens the PERSONAL.xls file

    Recently changed machine, but still running XP with Office Professional 2003. I've recorded a couple of macros but now whenever i open a file, or try to run the macro in a brand new workbook, it automatically opens the PERSONAL.xls file. I've checked the VB script and there is nothing in...

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