Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need someone to fill in the blanks:
Sub AddNodeCommas() For each C in Intersect Range("D2:D122") if c =*"/" substitute(c,c,c&",") Else Next End Sub What I want to do is add a comma to the end of the text in the cells if the cell does not contain a / (forward slash). I got a syntax error in here. this time I didn't forget the "'s tia, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Searching for a "LESS THAN"" amount within a sheet! | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
searching for cells that "contain" certain value | Excel Discussion (Misc queries) | |||
Can you "duplicate" "copy" listboxes and code to multiple cells? | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |