Hello,

I'm working on a macro that should find a value in column A of the active Excel sheet, return the row number to the API, and then use that value to tranverse the row using the values to create custom properties.  I was able to write a very simple macro that will use a hard coded row number to make the custom properties, but I can't figure out the finding the part about finding the value programmatically.  Does anyone have any thoughts on how to do this?  Also, can anyone point me toward a resource about the different excel functions available in the SolidWorks API?

Thanks in advance.