[ExcelVBA] need to find a specific column in a table

 

I have an Excel table where one of the columns contains our company's part number. This part number has the prefix MAX or DS followed by a number that is at least 3 digits long (examples: MAX123 or DS987).

The table dimensions can be several hundred rows and up to 30 columns. The column with the part number has no fixed location and can be anywhere.

How can I determine in VBA the number of the column that contains the Part Number?

I did not find anything wen googling this question. I hope somebody can help me with this challenge.
Thank you for your replies,
sunnywulf

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 6

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___