Hi
Normaly when you defind a name
then the name getal have a reference to for example =Blad2!$A$1:$A$3
So in vba i can get the value of the second rouw lik this.
But that workt in a normal sub. But when i do the same in the vba code under the sheet then i have a error.Please Login or Register to view this content.
the methode_range form object_worksheet is faild
Why ?
A person give me the folwoing
What is the use of [ in vba and { in worksheet formula'sPlease Login or Register to view this content.
Where can i find more of it ?
Bookmarks