passing range as a parameter to excel

[stanley]

can some one tell me how to pass the range as a parameter to excel.

i am using this excel sheet in vb.net

ObjWs1.Range("J3:J6").Select()
ObjWs1.Application.Selection.PasteSpecial(Paste:=Microsoft.Office.Interop.Excel.XlPasteType.xlPasteFormulas, Operation:=Microsoft.Office.Interop.Excel.XlPasteSpecialOperation.xlPasteSpecialOperationNone, SkipBlanks:=False, Transpose:=False)

I want to change the "J6" as a parameter. lets say that i want to pass it as total no of rows on the excel sheet.

pls help me.

thanks.