Macro: Setting a cell value from another cell
Closed
Cashel
-
Sep 19, 2009 at 08:36 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 19, 2009 at 08:46 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 19, 2009 at 08:46 PM
Related:
- Macro: Setting a cell value from another cell
- Spell number in excel without macro - Guide
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
- Run macro on opening workbook - Guide
- Excel vba assign macro to button programmatically - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 19, 2009 at 08:46 PM
Sep 19, 2009 at 08:46 PM
you want to color if any cell value is 87
use find function either as a formulla in speradsheet or in macro
example code statements
use find function either as a formulla in speradsheet or in macro
example code statements
dim cfind as range set cfind=activesheet.usedrange.cells.find(what=87,lookat:=xlwhole) cfind.interior.colorindex =41