| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is cell content text or numeric-need help with existing code
This will probably be an easy one for someone. I have the following code:
Dim rng1 as Range Sub test() Set rng1 = Range("A1") If rng1 = 1 Then rng1.Font.Bold = True Else: End If End Sub So if the content of cell A1 is the number 1, the code will bold the number. I want to generalize the "if" statement so that if the content of cell A1 is numeric, (any minus number, 0, or any positive number) the "if" statement will bold it, but if there is text in the cell, it will not bold it. How do I change the code to make that happen? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dividing existing content into two cells | Excel Discussion (Misc queries) | |||
| Changing the cell format doesn't change existing cell content | Excel Discussion (Misc queries) | |||
| How to add the same alpha-numeric value to all the content of a co | Excel Discussion (Misc queries) | |||
| Delete content of cell without erasing existing formula? | Excel Discussion (Misc queries) | |||
| Numeric content in one cell ( implicit formula ) and the result in another one | Excel Discussion (Misc queries) | |||
Threaded Mode
