Thread: Search column for string and write to cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Blee Blee is offline
external usenet poster
  
Posts: 6
Default Search column for string and write to cell
On Mar 3, 5:03*pm, Blee wrote:
On Mar 3, 4:37*pm, Blee wrote:

Thank you, Tom. Very interesting. And I can control which cell is
written to by using the Offset +/- values. Any way to actually specify
the cell by column letter?

Also, is there a flag for case insensitive searches?

ret = InStr(1, c, FindThis, vbTextCompare)
Reply With QuoteReply With Quote