In this post I am go Convert Visual Basic for Applications Macro to C# 4.0 , This is really easy one. I include youtube Video also..
See this video :-
[youtube=http://www.youtube.com/watch?v=at_ExhQLgm4]
VBA macro code :-
Sub Macro1()
ActiveCell.FormulaR1C1 = "1"
Range("A2").Select
ActiveCell.FormulaR1C1 = "2"
Range("A1:A2").Select
Selection.AutoFill Destination:=Range("A1:A10"), Type:=xlFillDefault
Range("A1:A10").Select
With Selection.Interior
.Pattern = xlSolid
.PatternColorIndex = xlAutom...
More