Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loop error
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stuck in an error loop | Excel Discussion (Misc queries) | |||
loop code error help!!!! | Excel Discussion (Misc queries) | |||
error on second pass of loop. | Excel Discussion (Misc queries) | |||
loop error | Excel Programming | |||
loop error | Excel Programming |