Hi Hari,

Sometimes using cells method to cut/paste etc. fails

I am not aware of this - except, perhaps, where cells references have not
been properly qualified.

Could you give an example?

---
Regards,
Norman



"Hari Prasadh" wrote in message
...
Hi Norman,

Sometimes using cells method to cut/paste etc. fails (I dont know why) but
If i change the same to Range(cells(i,j)) the same works fine. Hence
wanted to know if I can directly use ColumnCounter within Range.

Thanks a lot,
Hari
India

"Norman Jones" wrote in message
...
Hi Hari,

If numeric counters are being used, why depart from the elegantly,
simple Cells method?

Sub Tester07()
Dim i As Long, j As Long
Dim col As Long

For i = 1 To 20
For j = 3 To 40
Cells(i, j).Value = i ^ j
Next j
Next i

End Sub


---
Regards,
Norman