Do you want to rename the current sheet based on the dropdown or just jump to
a sheet based on the dropdown?
--
Gary''s Student - gsnu200715


"MCJM" wrote:

I want to reference the name of a worksheet to a specific cell within the
worksheet so that if I change a drop down box to look at differnt data, the
name of the worksheet changes.