Quote Originally Posted by mperrah
Shazam
I get a value error with this method
I tried with and w/o cse (ctrl+shft+enter)
It should be just enter. Can you post a sample of your workbook?

Quote Originally Posted by mperrah
btw
I grew up watching the TV show Shazam, any connection?
Mark
I wasn't born yet but I'm a huge Marvel Family fan. One of my favorite characters is black Adam and Captain Marvel.