Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing cells that have 2-3 letters
I'am have been unable to find a way to replace cells that have 2- letters only. I would greatly apperciate any help. Thanks in advance Dre -- drew ----------------------------------------------------------------------- drewd's Profile: http://www.excelforum.com/member.php...fo&userid=1474 View this thread: http://www.excelforum.com/showthread.php?threadid=26369 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing cells that have 2-3 letters
Dim cell as Range
for each cell in ActiveSheet.UsedRange.specialcells(xlconstants,xlT extValues) if len(cell.Value) = 2 or len(cell.Value) = 3 then cell.clearcontents end if Next Not sure what you want to replace them with - in the above, the cell is cleared. -- Regards, Tom Ogilvy "drewd" wrote in message ... I'am have been unable to find a way to replace cells that have 2-3 letters only. I would greatly apperciate any help. Thanks in advance Drew -- drewd ------------------------------------------------------------------------ drewd's Profile: http://www.excelforum.com/member.php...o&userid=14749 View this thread: http://www.excelforum.com/showthread...hreadid=263697 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacing cells that have 2-3 letters
What do you want to replace with? Do you mean clear these cells? Are there
cells that have numbers with only 2 or 3 digits, or is the column all text? On Sun, 26 Sep 2004 20:49:52 -0500, drewd wrote: I'am have been unable to find a way to replace cells that have 2-3 letters only. I would greatly apperciate any help. Thanks in advance Drew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replacing capital letters | Excel Discussion (Misc queries) | |||
Count only Letters in cells that contain both letters and numbers | Excel Worksheet Functions | |||
Replacing only the empty cells. | Excel Worksheet Functions | |||
Replacing letters for figures in formula | Excel Discussion (Misc queries) | |||
Replacing blank cells | Excel Worksheet Functions |