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.