View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Animal via OfficeKB.com Animal via OfficeKB.com is offline
external usenet poster
 
Posts: 7
Default Using two object variables

I did what you said, but that is not the problem I guess. Because I still get
an error.
The problem occurs in the statement:

1.At first I SET the currentMonth variable
2. Then I SET the d variable (that is based in currentMonth)
3. Then I SET the currentMonth to look for the next value. Set currentMonth =
Range("StartMonth:EndMonth").FindNext (currentMonth). Here it becomes nothing
for some reason.
But when I delete step 2 in the code, everything is as it is supposed to be
and worked well. But as soon as I set the d variable, it doesn't work. Weared
isn't it?

Could someone please help me? It have taken me days to worke this problem out,
and I haven't come up for a solution yeat, puhhhh....

Thanks in advance!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200707/1