Macros in Excel 2010

[Alabama Man]

How can I record following functions in Macro:
(1) Insert a column
(2) Use 'IF' function

The only macros I could record and use later were simple addition and subtarction.

 

[JLGWhiz]

You can record the insert part by clicking Developer on the ribbon, then click record macro, select the column where you want to insert by clicking on the column designation letter (i.e. A, B, C, etc.), then right click and select 'Insert' from the pop up menu. The insertion is now recorded.
The If statement you would need to write in at the point in the macro where it is logical to do so. Simple If statements like"

With ActiveSheet 'Use Sheets("Sheetname"<SHEET.NAME>) format where possible
 If .Range("A2") <> .Range("B2") Then
  MsgBox "Not Equal"
 Else
  MsgBox "Equal"
 End If
End With

Can be inserted anywhere in the code.

 

[Alabama Man]

You can record the insert part by clicking Developer on the ribbon, then click record macro, select the column where you want to insert by clicking on the column designation letter (i.e. A, B, C, etc.), then right click and select 'Insert' from the pop up menu. The insertion is now recorded.
The If statement you would need to write in at the point in the macro where it is logical to do so. Simple If statements like"

With ActiveSheet 'Use Sheets("Sheetname"<SHEET.NAME>) format where possible
 If .Range("A2") <> .Range("B2") Then
  MsgBox "Not Equal"
 Else
  MsgBox "Equal"
 End If
End With

Can be inserted anywhere in the code.

Thre is no easier method. So if I understand correctly, Macros do not record the functions directly, you have to copy the programmed coding.

 

[shg]

The recorder can do no more than record what you do in the user interface.

 

[JLGWhiz]

Thre is no easier method. So if I understand correctly, Macros do not record the functions directly, you have to copy the programmed coding.

I don't think I implied that. There are certain things the recorder cannot record because that particular portion of code is dependent on human rekoning and the recorder facility was not designed to handle that. But, as shg says, it can do more than what you do in the user interface. There are turtorials on using the recorder if you browse the web, you can probably find a free one that will help you out.

 

[Alabama Man]

I don't think I implied that. There are certain things the recorder cannot record because that particular portion of code is dependent on human rekoning and the recorder facility was not designed to handle that. But, as shg says, it can do more than what you do in the user interface. There are turtorials on using the recorder if you browse the web, you can probably find a free one that will help you out.

Thanks,

 

[gardnertoo]

When you say you want to record "use the IF function", are you wanting to record what it looks like to use a cell formula containing an IF statement? You can do that by typing such a formula in a cell during the recording. You will end up with a line of code that looks something like this:

ActiveCell.FormulaR1C1 = "=IF(RAND()>0.5,""Big"",""Small"")"