record macro

  1. 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:)
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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 :)
  7. 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...
  8. 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...
  9. 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")...
  10. 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...
  11. 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...
  12. 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...

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