In my macro I'm using the below formula:The RC[-33alue is a guess. It's the "Employee ID" column, sometimes named "EmplID", sometimes named "ID", and sometimes named something outlandish like "User Number". It can also exist in a different location, so it might be in D, G, Z, really anywhere in the sheet.Please Login or Register to view this content.
I'm starting my process by picking one cell to start with for all the formulas and columns I need to put in. I've got my entire macro working fine, but want to fine tune this particular formula.
My question is, how would I find, for instance, the value "ID" or "Number" in a column and determine the offset from my active cell to that column, to capture it as a variable to insert in my formula?
Bookmarks