Have the user select the correct sheet first.

Then you can write your macro to work against the Activesheet.

With Activesheet
.range("a1").clearcontents
end with

For example.



lbargers wrote:

Hey Dave,

I should of explained myself better, I would like the code in a Module,
this way the user will not have to select between multiple macros. The
user should be able to select any sheet in the workbook and exectue the
macro..

Thanks

Larry

--
lbargers
------------------------------------------------------------------------
lbargers's Profile: http://www.excelforum.com/member.php...o&userid=32798
View this thread: http://www.excelforum.com/showthread...hreadid=532978

--

Dave Peterson