Hi,
I was wondering if it is possible to write a quick script that will find all cells in a given worksheet (not the whole workbook) that have a red font color (RGB code 255, 0, 0), and paste those cells as values.
For context, I have a worksheet with a bunch of links to other worksheets in a workbook. All the links to other worksheets are colored red. I want to be able to delete those other worksheets without impacting my active worksheet. To do that, I would like to paste all the links to other worksheets as values, and then delete those tabs (since they are no longer referenced on the active worksheet). I was thinking that writing a script that finds all the red font cells and pastes them as values would work, but it would also work to have a script that pastes as values only the cells in an active worksheet that link to another worksheet.
Thanks for the help!
I was wondering if it is possible to write a quick script that will find all cells in a given worksheet (not the whole workbook) that have a red font color (RGB code 255, 0, 0), and paste those cells as values.
For context, I have a worksheet with a bunch of links to other worksheets in a workbook. All the links to other worksheets are colored red. I want to be able to delete those other worksheets without impacting my active worksheet. To do that, I would like to paste all the links to other worksheets as values, and then delete those tabs (since they are no longer referenced on the active worksheet). I was thinking that writing a script that finds all the red font cells and pastes them as values would work, but it would also work to have a script that pastes as values only the cells in an active worksheet that link to another worksheet.
Thanks for the help!