Looking for help trying to develop a user-defined function that takes column numbers from a range, and concatenate's together a sheet name and a row number inputted from the UDF.
Having trouble developing a loop that would stop when the column range hits zero (hint: the first column in the range will always be populated, but not always the second). Any ideas? Much appreciated.