Re: Function result differs from same code for subroutine

Ken,

Thanks for your input, I dont think I was clear enough...

Am in the middle of developing this but I happend on this problem as I
was testing what c.value would return.

the debug.print statement returns completly different results. While
in the subroutine it does indeed debug.print the values of my filtered
cells, with the function it debug.prints everything!!

Am just lost as to why it would return different results.

at the end of the day i need the function will return the second
SpecialCells(xlCellTypeVisible) like the subroutine does, but rignt now
the 'function' isnt behaving!

hope i made this clearer, its doing my head in. :\

.

Relevant Pages

  • Game Controller Hardware Problem
    ... my Gravis connections in the Game controllers ... happend but they just disappeared. ... this i dont know how it happend ...
    (microsoft.public.windowsxp.hardware)
  • Navigation Fails in Forms!!!!!!!!!!!!!!!!
    ... from the sencond form to third, ... showing that form again, no items are displayed in the list box. ... I dont know what happend. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: help with module
    ... should be available to all other prgrams; ... The "protected" attribute was a good idea, dont give up too early. ... end subroutine set_speed_of_light ... except when explicitly calling set_speed_of_light. ...
    (comp.lang.fortran)
  • rundll32.exe Error
    ... i dont know what to put it under and o i will get more ... have no idea why this would come up and it just happend ... I was woundering if there is somebody out ... there that knows anything aobut this error and how to fix ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: My mate gets speed ticket doing 31 on a 30 Zone i mean come on!
    ... Yeah i come on here about something that happend to my mate, ... and i dont need this bullshit. ...
    (uk.transport)