User Defining A Cell Range

I'm having some issues getting a tool I'm working on to function correctly. I have some cells, the number of which can vary based upon user requirement, that contain cell addresses. What I need from VBA is to translate these addresses into usable row, column values for the user defined range. Example:

Cell D4 contains F14, which was input by the user.

What is the best way to pass this data through VBA. Right now I am currently using:

Code:

Dim strRange as String 'left out loop parameters
dim TempRange as Range
strRange(i) = Cells(4, 4) 'using TypeName on StrRange at this point yields a string result as expected
set TempRange = Range(strRange(i))

From my understanding that should work but I am getting type mismatch.

I do not have any reason for actually using a string, but would like the user input to only be 1 cell. If there are cleaner ways around this, I am open to them.

Then from the range, I would have two other variables as type long for storing the row and column data using:

Code:

Pathing_Rows = TempRange.Row
Pathing_Cols = TempRange.Column