Hi there,

I currently have VB (extract below) that says

Set sh = bk.Worksheets("James")
Set dest = ThisWorkbook.Worksheets(1).Cells(i, 1)
i = i + 1
sh.Rows(3).Copy

I want to change the last line of text to enable me to select all rows
with text in at least column A, or if thats too dificult then to select
from row 1 to row 300, what is the syntax for the last line of code...

Thanks

D

*** Sent via Developersdex http://www.developersdex.com ***