Posts by jlsprink

Thanks Derk, Richie,

Both worked great! I've been trying for hours, but just couldn't quite get it. Figured I'd yield to the experts! Thanks so much for your help!

JL

Hi All,

All I'm trying to accomplish is this. If there is a cell in column B that has a formula in it, I'm trying to create a macro that will copy that formula into the adjacent cell in column A. Any help would be appreciated. Thanks!!
JL

Yeah!! Thanks Derk,
Works just how I was hoping. :yes:
Thanks for your time and effort!!

Hi All,

Here's what I'm trying to accomplish. If there is any value in a particular range of cells, I'd like to lock a separate cell that is not in the range. For instance:
If there is any value in the cells in the range A1:A10, I would like to lock cell B1 so that it cannot be modified. Make sense??

I'd appreciate any input.
Thanks!
JL