View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] john.9.williams@openreach.co.uk is offline
external usenet poster
 
Posts: 15
Default counting number of columns

Hi,

i am using a find action to find a specific value in a multi column
list.

i can find the value no probs and can return the cell reference the
valueis in.

What i now need to do is use that cell in an offset statement.

i need to find out how many columns over from A1 that my find data is
in.

For instance if my find data was in column d, i would use the offset
number 4

any help greatly appreaciated