hi,

i have a userform which i use to create the formulae for dynamic ranges.
when it initializes, it bases itself on the currently selected cell, which
works fine. however, i noticed the other day that if some other object is
selected (in this case, a chart) the VBA returns an error.

how can i determine what sort of thing is selected when the form is
initialized? the user form uses a RefEdit control (I know, I know!), so i
wouldn't really want the form to close, as the user would have the chance to
select a range whilst the form is still open.

tia,

Tim