Converting Cells to range

I have VBA code where I cycle through rows (r) and columns (c) using for loops to find a value in a cell. Once I find that value I want to use the row and column values to save a defined range variable for use later

Please Login or Register  to view this content.

I am trying to research the format for saving the cells(r,c) as range format with column as letter not number

Thank you both for your answers. I guess now that I am thinking about it and looking at the scenario, I might need to change up my logic. I am parsing a PDF into excel tabs. I then look for certain header text in a row to define which tab I need to use to parse the data (could be different each time I import the PDF).

I have the code to cycle through each workbook, but instead of going through each row and cell to find a text value I could use range.find or worksheetfunction.match.

I think to cover all possible scenarios, I need to try to match multiple text values that will be on a single row, but no necessarily next to each other. Would it make sense to find the row of the first text value and then find the second text value row and see if they are on the same row? Is there an easier way?