Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text formatting
Want macro that will work on a range I select that will look at the contents,
if apostrophe at beginning then no action, if not, it will add so cell contents are formatted text. THX |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text formatting
Scottie,
This should be a start: Sub Sub1() Dim s1$, zCell As Range For Each zCell In Selection If zCell.PrefixCharacter < "'" Then s1 = zCell.Value zCell.Value = "'" & s1 End If Next zCell End Sub ' D-C Dave Scottie wrote: Want macro that will work on a range I select that will look at the contents, if apostrophe at beginning then no action, if not, it will add so cell contents are formatted text. THX ----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet News==---- http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups ----= East and West-Coast Server Farms - Total Privacy via Encryption =---- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Text in cells that already have text entered | Excel Worksheet Functions | |||
copying text within a text box and losing formatting | Excel Discussion (Misc queries) | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Conditional Formatting based on text within a cell w/ text AND num | Excel Worksheet Functions | |||
Formatting text in a user form text box | Excel Programming |