Hi All,
I want to have a button that will run a macro to change any cell in a range that has the value of "-" to "md" (for 'Missing Data', as this is what the program will detect).
How can I write the code for this? For reference, the column that I would like the changes to be made in is column I and the range is around 800 rows.
Thanks in advance!
I want to have a button that will run a macro to change any cell in a range that has the value of "-" to "md" (for 'Missing Data', as this is what the program will detect).
How can I write the code for this? For reference, the column that I would like the changes to be made in is column I and the range is around 800 rows.
Thanks in advance!