How do I update Excel 2000 macros to work in Excel 2002?

Working in Excel 2002/XP on an Excel worksheet which was created in Excel
2000, I get an error message "Subscript out of range". How do I update the
macro to work in Excel 2002?

Hi
normally the macro should work without a problem. Best to post the part of
your code which generates this error

--
Regards
Frank Kabel
Frankfurt, Germany
"BobPetrich" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> Working in Excel 2002/XP on an Excel worksheet which was created in Excel
> 2000, I get an error message "Subscript out of range". How do I update
> the
> macro to work in Excel 2002?

And where do I find "that part of the code which generates this error"? (I'm
a novice at macros). Thank you!

"Frank Kabel" wrote:

> Hi
> normally the macro should work without a problem. Best to post the part of
> your code which generates this error
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
> "BobPetrich" <[email protected]> schrieb im Newsbeitrag
> news:[email protected]...
> > Working in Excel 2002/XP on an Excel worksheet which was created in Excel
> > 2000, I get an error message "Subscript out of range". How do I update
> > the
> > macro to work in Excel 2002?
>
>
>

Hi
then the error occurs you should have the option 'Debug#. Then you should
see the code.

--
Regards
Frank Kabel
Frankfurt, Germany
"BobPetrich" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
> And where do I find "that part of the code which generates this error"?
> (I'm
> a novice at macros). Thank you!
>
> "Frank Kabel" wrote:
>
>> Hi
>> normally the macro should work without a problem. Best to post the part
>> of
>> your code which generates this error
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>> "BobPetrich" <[email protected]> schrieb im
>> Newsbeitrag
>> news:[email protected]...
>> > Working in Excel 2002/XP on an Excel worksheet which was created in
>> > Excel
>> > 2000, I get an error message "Subscript out of range". How do I update
>> > the
>> > macro to work in Excel 2002?
>>
>>
>>