vb macro, excel 2002/2003, application.goto reference=******?

no research so far has worked. Forget mrexcel.com. i have a drop down list box with 88 counties.

Cell N1 is the current cell as an absolute reference.

Cell N2 contains the index number of the county chosen (e.g., Perry=6)

Cell H8, when all is said and done, needs the value of 6 based on a VB formula or function.

Manual Steps:

- Select correct county from a drop down list.

- The value of the county shows up in N2 correctly.

- Select one of the cells in the County column (range H8:H22) one at a time.

- Press the "Do It" macro button.

Cell H8 (or whatever cell you pick in the H8:H22 range) needs to contain the value 6 as the result of a VB Macro as follows:

Sub WTFE() (pseudocode)

' County chosen, correct value in N2

' Appropriate cell chosen for county code to show up in.

CALCULATE (makes cell N1 have the "value" $H$8)

Range ("N2").Select (choose the cell that has the county code)

Selection.Copy (copy the 6 to the clipboard)

*** This is the pain in the ***. Nothing works that I tried or googled.

*** This is where I could use some help. I am trying to do an Indirect

*** Reference in an Application.Goto VB Statement to "go to the cell

*** referenced in cell N1" and make it the current cell ($H$8).

Neither statement below works. MS Docs are no help either (big fricking surprise there...)

Application.Goto Reference:="INDIRECT(N1)"

(the statement above causes the macro to crash. I DON'T want

to hardcode an "R1C1 or A1" reference as the cell will change constantly. The county value (6) has to be pasted in the Current Cell).

ActiveSheet.Paste (now the 6 shows up in the chosen/current cell).

***************************************************************************

I would rather not have a formula but if that seems to be easier then go for it. I hope you see my logic and can follow it.

I am not a high school or college kid wanting free homework help. I am 53 and this is part of my personal budget worksheet. What I wanted to be able to do is buy something anywhere in Ohio and have it calculate the right Sales Tax based on the County where the item was bought.

Thanks much!!!