Find(SPELER, LookIn:=xlValues) problem with hidden colloms!!!
Hi Isabele,
what you wrote is a good help for the macro but it didn't solve the
problem..:-(
The problem is that when i hide the Collum "J"
the "Set C2..." line doesn't work
so the macro returns
"lege regel"
when i unhide the collum "J" the macro works fine..
so my question is..
is there a way to use the line
"Set C2 = Sheets("Spelers").Range("J2:J65000").Find(SPELER,
LookIn:=xlValues)"
with a hidden Collum.
gr.
Swingleft
"Swingleft" schreef in bericht
bel.net...
Hallo,
somewere in the middle of my macro is the next part
Set C2 = Sheets("Spelers").Range("J2:J65000").Find(SPELER, LookIn:=xlValues)
If C2 Is Nothing Then
MsgBox ("lege cel")
Else
Range(C2.Address).Offset(0, -9).Value = ""
End If
THe function works oke BUT
If i Hide Collum "J" this part of the macro does't work anymore.. is the
correct?
And does anybody know a reason for this.. and a solution?
thanks for all the help.
Swingleft
|