Posted to microsoft.public.excel.programming

mel

external usenet poster

Posts: 6

Shorten Code for repeated function use

I use the following command to replace characters in a
string which are not allowed. I use this command up to 30
times to remove all of the unwanted characters. Is there
a way to set up an array and get the function to work
with one value after another in the array rather than
having a separate statement for each occurrence?

ReplNameChar = Application.WorksheetFunction.Substitute
(ReplNameChar, "&", "_and_") ' remove &

TIA

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Which function will shorten IF-THEN-ELSE ?	Jack Ryan	Excel Worksheet Functions	5	May 19th 10 09:03 PM
Which function will shorten IF-THEN-ELSE ?	Jack Ryan	Excel Worksheet Functions	0	May 18th 10 10:02 AM
function for repeated cells	Haz	Excel Worksheet Functions	7	June 3rd 07 08:56 PM
Printing text in a repeated cell/row that is longer than repeated	Valerie Dyet	Excel Discussion (Misc queries)	1	February 13th 06 03:27 AM
Shorten Code?	Rockee052[_23_]	Excel Programming	5	January 28th 04 12:49 AM

All times are GMT +1. The time now is 09:53 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us