I tried the myWS method cos i wanted to specify the colume too. but i
coulndt get it to work. one thing i spottte was:-

(myRow, myCol).

normally its colum then row, eg B10

any ideas why. this is what i have
Dim myWS As Object
Dim myRow As Integer
Dim myCol As Integer
myRow = 10
myCol = 2

' myWS.Cells(myCol, myRow).Select
myWS.Cells(myRow, myCol).Select


---
Message posted from http://www.ExcelForum.com/