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

Some videos you may like

This Week's Hot Topics