loop error

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top