The Offset method would suit you better for this operation.

Instead of the Do loop

Use

ActiveCell.offset(linecnt-tempcnt,0).activate

Thanks so much for the line of code. Works great. Do you have
another great resolution for this problem? I have to multiple each
cell together. The cell  range will vary depending on how much data
the user enters. For example,

c1 10
c2 20
c3 20

formula c1*c2*c3

You would need to write a function which

1) identified the range to be multiplied

(probably select C1 and then extend selection end down)

2) stepped through the range multiplying each cell.value as it went

3) returned the final product

I do not have the time to do this just now. How about you try it and let us
know if you have problems.

The function would need to be in a Module not in the sheet code. Then you
just refer to it by entering its name (with the following parentheses) in a
cell.

I guess the real question is, is there a way to
determine what cell  you are in? I can move through
the cells but don't know how to get the cell address.

You might mean

ActiveCell.Address