Thread
:
Array code only works on selected sheet
View Single Post
#
15
Posted to microsoft.public.excel.programming
Howard
external usenet poster
Posts: 536
Array code only works on selected sheet
that is because you use LookAt:=xlPart in your code.
Change it to LookAt:=xlWhole
Regards
Claus B.
Well, that solved that in a blink.
Thank you.
Regards,
Howard
Reply With Quote
Howard
View Public Profile
Find all posts by Howard