If you don't have to show it in the upper left corner of the window, then
just execute the Show method for it... that will make it appear at the
bottom of the window. For example,

Range("F150").Value = "XXX"
Range("F150").Show

--
Rick (MVP - Excel)


"Andre" wrote in message
...
I have single cells that have range names. Simple selection macros select
it. problem is that it is not displayed in the upper left corner of the
window, I have to manually scroll to show the cells below the named cell.
I know it's simple but I can't locate any reference to it in the books I
have. any help would be appreciated, thanks