Macro to change value 2 cols over from search
I'm not to good a complex macros so If someone could help I'd much
appreciate it.I like to create a macro to change to value of a cell 2
cols left of a search string,same row.I have a sheet with 25 cols and
7500 rows,at various places the string oz is in a cell,I need to change
the value in the cell 2 cols left,how could I do this with a macro
?.The search string is usually but not always the same col,the value to
be changed is always second col left. Thanks
SteveC
|