| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need some code help please
in the following code, i get the name from another sheet. if it's blank, it
just gives me the name, but if there is another name that goes in the same cell, i put a / between them how would i put a chr(10) after every 2nd name, so only 2 fit on a line in each cell. If .Value = "" Then .Value = Left(Fname, Len(Fname) - 4) Else .Value = .Value & "/" & Left(Fname, Len(Fname) - 4) End If -- Gary |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| split post code (zip code) out of cell that includes full address | Excel Discussion (Misc queries) | |||
| Drop Down/List w/Code and Definition, only code entered when selec | Excel Worksheet Functions | |||
| How to make a button VBA code reference other VBA code subroutines??? | Excel Programming | |||
| run code on opening workbook and apply code to certain sheets | Excel Programming | |||
| stubborn Excel crash when editing code with code, one solution | Excel Programming | |||
Threaded Mode
