Restrict Loop Range To Used Cells

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!