Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replacement
Hi, If the number in column 3 is 3 and the 1st digit of the number i column 5 is 2 I have to replace this with 1 the following is an excerpt of my code which isnt working, Many Thanks For i = 1 To lastrow If cells(i,3) = 3 and left(Cells(i, 5),1) = 1 Then Cells(i,5) = Replace(Cells(i,5), 1, 1, "1") 'End If 'Nex -- T De Villier ----------------------------------------------------------------------- T De Villiers's Profile: http://www.excelforum.com/member.php...fo&userid=2647 View this thread: http://www.excelforum.com/showthread.php?threadid=56372 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value Replacement | Excel Worksheet Functions | |||
#N/A Replacement | Excel Discussion (Misc queries) | |||
Replacement | Excel Discussion (Misc queries) | |||
Replacement CD | Excel Programming | |||
Bad Office CD -- how do I get a replacement. | Excel Programming |