range variable

In VBA, how can I select a cell if the column is a constant and the row is a variable?

Thanks!!!!!!!!!

That was exactly what I was looking for.
I was able to use it to look up an item in a list on a separate sheet and return the item with the formatting intact.