Without knowing what your code looks like, maybe you can just refer to the
activesheet instead of referring to a sheet by its name:

With activesheet
.range("A1").value = "hi there"
.range("x9:z99").clearcontents
end with



Jeff, Modares wrote:

Hi All,
Excel 2007. I have a sort and format macro that I use in similar worksheets with different names. I don't know how to tell the macro to not to include the sheet name. Any help is greatly appreciated.

Jeff.

EggHeadCafe - Software Developer Portal of Choice
WPF And The Model View View Model Pattern
http://www.eggheadcafe.com/tutorials...l-view-vi.aspx

--

Dave Peterson