Assign active cell in macro with Dynamic Cell choice

Afternoon all,

Before unloading a userform the range to select the active cell is set to

Please Login or Register  to view this content.

to set the active cell to the second row of a named range (Budget) in the first colum which is labeled "JAN" I would like to replace this with a dynamic choice based on a HLOOKUP, where the "mmm" portion of $E$1 is matched to a label in (Budget) and the cell in the second row of that matched colum becomes the active cell.

I was thinking it to be something like this

Please Login or Register  to view this content.

however I get a syntax error when trying to use it.

Any suggestions???

As always, many thanks for your time.

Without knowing all particulars you could perhaps try something along lines of:

Please Login or Register  to view this content.

Hi DO,

I know your preference of using WS functions. It works, but I just wanted to give an alternative

Please Login or Register  to view this content.

Both suggestions provide the desired results. Thanks for the lesson, your help is always appreciated!