Macro
Closed
KarenPostell
Posts
2
Registration date
Wednesday August 17, 2016
Status
Member
Last seen
August 17, 2016
-
Aug 17, 2016 at 02:13 PM
KarenPostell Posts 2 Registration date Wednesday August 17, 2016 Status Member Last seen August 17, 2016 - Aug 17, 2016 at 02:18 PM
KarenPostell Posts 2 Registration date Wednesday August 17, 2016 Status Member Last seen August 17, 2016 - Aug 17, 2016 at 02:18 PM
Related:
- Excel macro forum
- Spell number in excel without macro - Guide
- Excel marksheet - Guide
- Excel free download - Download - Spreadsheets
- Macros in excel download - Download - Spreadsheets
- Kernel for excel - Download - Backup and recovery
1 response
KarenPostell
Posts
2
Registration date
Wednesday August 17, 2016
Status
Member
Last seen
August 17, 2016
Aug 17, 2016 at 02:18 PM
Aug 17, 2016 at 02:18 PM
Sub What_color ()
Dim Cell as Range
For each cell in range ("a:2:a4955")
If cell.interior.colorIndex = 3
Then cell.value = "red"
Next cell
End sub
Dim Cell as Range
For each cell in range ("a:2:a4955")
If cell.interior.colorIndex = 3
Then cell.value = "red"
Next cell
End sub
