S
Sam
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
-------------------------------------------------------------------
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