Move cursor to a specified cell based on the address shown on cell A1

I have a formula in cell A1 which would give a cell address,say, B2.(it will vary from time to time)
Is it possible to move cursor to the cell that A1 shows.(i.e. move cursor to B2 in this case.)
Sorry, I am very new to excel VBA, I'll be very appreciated to anyone willing to help me.
Thanks.

This could be simplified down to a line or two but i left them in so that hopefully you can better understand what is going on:

Please Login or Register  to view this content.

hi mpegwmvavi, option

Please Login or Register  to view this content.