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.
dim t1 as integer
t1= getal.cells(2)
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.
the methode_range form object_worksheet is faild
Why ?
A person give me the folwoing
dim t1 as integer
t1= [getal].cells(2)
What is the use of [ in vba and { in worksheet formula's
Where can i find more of it ?
Bookmarks