If separates a worksheet name from the range being used, such as

Sheet1!A1:A10

--
HTH

Bob Phillips

"Marsha" wrote in message
...
In excel, what does the esclemation point (!) in a function mean?