View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Robert[_30_] Robert[_30_] is offline
external usenet poster
 
Posts: 44
Default VBA, copy lines with specific value

Hi Bob,

Thanks a lot for the promt assistance!
When running the statement I get an error for .Rows(i).Copy
Worksheets("Sheet2").Cells(INextrRow,"A")
Can it be that you have to include some sort of offset function to
paste the first line in say A1 and for the following lines something
like End(xldown).Offset(1, 0).Select?
Thanks again
Rgds,
Robert