Hi
I am trying to write a macro to basically find a value in a variable range of data and then amend that value to another value (effectively want to do a loop macro as the data files will vary from 5 rows of data to 100+
Basically if a cell = icelolly then it should change to lolly, i have tried it with find and replace but it just is a bit too easy for it too fall over, especially as i have 11 different values i need to amend. and possibly more at a later stage.
I have tried writing an if command but it doesnt seem to work and i cant figure out what i am doing wrong.
if someone could point me in the right direction would be appreciated.
thanks
I am trying to write a macro to basically find a value in a variable range of data and then amend that value to another value (effectively want to do a loop macro as the data files will vary from 5 rows of data to 100+
Basically if a cell = icelolly then it should change to lolly, i have tried it with find and replace but it just is a bit too easy for it too fall over, especially as i have 11 different values i need to amend. and possibly more at a later stage.
I have tried writing an if command but it doesnt seem to work and i cant figure out what i am doing wrong.
if someone could point me in the right direction would be appreciated.
thanks