1. In XL2000 and XL2002 VBA, there is no such thing as
"ACTIVESHEET.PASTELINK=TRUE".
Do you mean "ActiveSheet.Paste Link:=True" ?
2. This is still (potentially) valid syntax. Maybe you have other errors
preventing compilation.
NickHK
"pmonica" wrote in message
...
Dear All,
I was working in the past with Excel 2000, where I have made most of my
VBA
macros.
Now I have installed Excel 2003 and some of the commands are not working.
Just to examples:
1. In the VB editor, when you write "ACTIVESHEET.PASTELINK = TRUE", all
the
"unnecessary" caps would be desapearing. In my 2003 excel the LINK remains
with caps and the instrution is not working.
2. In the VB editor, when you write "SELECTION.VALUE = "bla-bla"", all the
"unnecessary" caps would be desapearing. In my 2003 excel the VALUE
remains
with caps and the instrution is not working.
Help please.
--
Paulo Mónica