Re: $$Excel-Macros$$ copy only yellow cells

Thank you sir -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ copy only yellow cells

This can be done fairly easily with VBA:Sub CopyCells()     Dim Rng As Range, nRow     '---     Sheets("Sheet1").Cells.ClearContents     nRow = 0     '---     For Each Rng In Sheets(1).UsedRange    

$$Excel-Macros$$ copy only yellow cells

I want to copy only yellow cells in different column at the same time and paste it in another blank sheet -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM