Hi guys, I have a question.

Why is it that every time after I had run a macro on a set of data, if
I copy and paste another set of data over the original data and try to
run the macro again, the macro does not work?

I always have to open a fresh copy of the spreadsheet, then copy and
paste values into the cells.

Why is that?

Thanks in advance.

-Tom


--
Etrnal168
------------------------------------------------------------------------
Etrnal168's Profile: http://www.excelforum.com/member.php...o&userid=25135
View this thread: http://www.excelforum.com/showthread...hreadid=386327

Post your code and someone may see the problem.

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"Etrnal168" wrote
in message ...

Hi guys, I have a question.

Why is it that every time after I had run a macro on a set of data, if
I copy and paste another set of data over the original data and try to
run the macro again, the macro does not work?

I always have to open a fresh copy of the spreadsheet, then copy and
paste values into the cells.

Why is that?

Thanks in advance.

-Tom


--
Etrnal168
------------------------------------------------------------------------
Etrnal168's Profile:
http://www.excelforum.com/member.php...o&userid=25135
View this thread: http://www.excelforum.com/showthread...hreadid=386327

Can someone please help me out?

Thanks so much.

-Tom


--
Etrnal168
------------------------------------------------------------------------
Etrnal168's Profile: http://www.excelforum.com/member.php...o&userid=25135
View this thread: http://www.excelforum.com/showthread...hreadid=386327