yes, but it should do for all the rows where ever B is there.
i am writing in vba. i am getting a value in one worksheet and putting it another worksheet searching for that column value B and putting value where ever B is there in that column This message was edited by jkpd2000 on 2002-10-30 16:38
Not really, especially given the "all the columns" remark - I assume you don't mean all 256 available columns. you'll really need to be more specific. please post back with a complete, worked example. if the code you're using is relevant, post it up.