Better vba to select all cells in a range if cell interior colour is not green

[lynnsong986]

I know how to loop through each cell to get this done (basically convert all cells to value except for cells in green), I wonder if there is a quicker way by selecting all non green cells in used range, set these as a range/array and convert to value all at once. This is more of a speed issue.

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[NickyC]

Hi
I'm not sure you'll save much time, as you'll have to loop through cells anyway to find those that aren't green.

this will loop through cells in the used range and convert non-green cells to values, but it sounds like you have that covered anyway

Please Login or Register  to view this content.

[lynnsong986]

Thanks NickyC for replying, I do have something similar but thanks anyways!

[Fluff13]

Not sure how much difference this will make, but you can limit the loop to cells that contain formulae

Please Login or Register  to view this content.