Issue with copy & paste?

[Etrnal168]

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]

Can someone please help me out?

Thanks so much.

-Tom

[Damon Longworth]

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>