I saw your answer to my excel query, and i was quite impressed with your
presentation...THANK YOU.

Now, I have a different question Copying and Pasting functions from
1 cell to another.

FOR EXAMPLE: I have a column of names, 25, of them, in A1 through A25.

I have an ENTERED formula in B1...,for example,...
=IF(A1="Larry", TRUE, FALSE)

If I paste this formula to B2:B25...my A1 becomes A2:A25

BUT I WISH TO KEEP EACH CELL in the B column as A1 !!

for example, my 12th entry should read:

=IF(A1="Larry", TRUE, FALSE) NOT =IF(A12=....etc.)

Is there a paste special (or whatever that can handle this)

thanks,

Larry




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