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