Hi Darin

did you do insert / module and paste the function in there - or did you
paste the function into "ThisWorkbook" - the former option works for me.

BTW i used Bob's version of the code.

Cheers
JulieD

"Darin Kramer" wrote in message
...


Unfortunately I get an #/Value error when pasting that into the workbook
VBA module, and then within the worksheet referncing a cell (say b11 =
fzlastvalue(A1:b10)

Ideas most welcome... Im just trying to select a block of text....(size
not always known..)

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!