When value appears adjacent cell acknowledges
Closed
SJJ
-
Feb 12, 2012 at 12:20 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 16, 2012 at 09:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Feb 16, 2012 at 09:38 AM
Related:
- When value appears adjacent cell acknowledges
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Run macro when cell value changes - Guide
- It appears that call of duty did not quit - Call of Duty (CoD) Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- Excel if cell contains date then return value ✓ - Office Software Forum
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Feb 16, 2012 at 09:38 AM
Feb 16, 2012 at 09:38 AM
Hi SJJ,
Why use VBA for this?
Select column B, goto cell properties (Ctrl+1), number tab, bottom option and enter 00# in the "Type:" field.
Now enter the following formula in cell B1:
=IF(C1="","",ROW(C1))
Drag formula down as far as you like.
Best regards,
Trowa
Why use VBA for this?
Select column B, goto cell properties (Ctrl+1), number tab, bottom option and enter 00# in the "Type:" field.
Now enter the following formula in cell B1:
=IF(C1="","",ROW(C1))
Drag formula down as far as you like.
Best regards,
Trowa