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
- Excel online macro - Guide
- Macro for number to words in excel - Guide
- Excel run macro on open - Guide
- Excel macro download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - 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