Tom... please bear with me b/c I really have very little experience with
macros...

In this part of the code:

Set ws1 = Sheets("Sheet1") '<<< Change
'Tip : Use a Dynamic range name,
http://www.contextures.com/xlNames01.html#Dynamic
'or a fixed range like Range("A1:H1200")
Set rng = ws1.Range("A1").CurrentRegion '<<< Change

I'm supposed to change which variables? Is the below correct?
"Sheet1" should be the name of the worksheet I'm running the code in.

What do I need to change in the 2nd line of code?

Thanks again for all your help! I really really appreciate it...


--
NeedsExcelHelp4
------------------------------------------------------------------------
NeedsExcelHelp4's Profile: http://www.excelforum.com/member.php...o&userid=31898
View this thread: http://www.excelforum.com/showthread...hreadid=516298