Thread: Find in column and copy
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Find in column and copy
Hi Syson,

vText = ActiveCell.offse(0,1).Value

was intended as:

vText = ActiveCell.Offset(0,1).Value


---
Regards,
Norman


Reply With QuoteReply With Quote