View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)[_1657_] Rick Rothstein \(MVP - VB\)[_1657_] is offline
external usenet poster
 
Posts: 1
Default Get column reference after string found

Showing the code would have been helpful. If that code is finding the Cell
(as a range) that the text is in, then just affix .Column (note the leading
dot) after that range to get the column.

Rick


"Les Stout" wrote in message
...
Hi all, i need to find a string on a spreadsheet and once found i need
to get the column that it is in. Could anybody help me with some code
please ?
I have the find string code, i just need to know how to get the column
that the string is in.


Best regards,

Les Stout

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