i have the foll code :
-------------------------------------------------------------------
For i = 1 To Cols
'...select Col i from increment, paste to inputs starting ColB
Sheets("increment").Columns(i).Copy
Sheets("inputs").Columns(2).PasteSpecial Paste:=xlValues
'...Copy Sheet3 Row 1 to Row i in Sheet 4

Sheets("value").Rows(i).Value = Sheets("main").Rows(3).Value
'ActiveWorkbook.Save
Next i

---------------------------------------------------------------------------
in the line below......
Sheets("inputs").Columns(2).PasteSpecial Paste:=xlValues


instead of columns(2) , want it to take row 2 column 2 ......how do i do that ?

i cant use rows(2).columns(2).....

can someone help ?

sam