relate row numbers to column numbers

[DPJW]

I have a list in a column, rows 1 to 5 with each cell containing text. When the text I'm looking for is found I want to make the row number to relate to a column number as follows
Row 1 relates to column 3
Row 2 relates to column 5
Row 3 relates to column 7
Row 4 relates to column 9
Row 5 relates to column 11

How can this be achieved in vba?

many thanks in anticipation

[Leith Ross]

Hello DPJW,

This is a simple arithmetic progression which can be define as (row* 2) + 1. You can search for the text in the range using the Find method.

For example, say your range is "A1:A5". The following code will display the column number in a message box when found.

Please Login or Register  to view this content.

[Winon]

@ Leith Ross,

I like! Nice short neat and clean.

Kind Regards.

[DPJW]

Thanks that is just what I was looking for. I was thinking of using Ifs but this is so much better. I was also having problems getting to an arithmetic sequence.
So thank you

Best regards