| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find value (31.12.9999) and clear
Hi all, i am back again !! I can clear all cells with the value above In
the column "CA" by using a loop statement, but is there perhaps a better way ?? regards, Tempy *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find value (31.12.9999) and clear
Search-replace perhaps ?
Glad you're back. Best wishes Harald "Tempy" skrev i melding ... Hi all, i am back again !! I can clear all cells with the value above In the column "CA" by using a loop statement, but is there perhaps a better way ?? regards, Tempy *** Sent via Developersdex http://www.developersdex.com *** |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find value (31.12.9999) and clear
Yip, i used the following:
Sub RemoveWrongDate() ' Range("CA:CA").Select Selection.Replace What:="(31.12.9999)", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Range("A1").Select Columns("A:EP").EntireColumn.AutoFit End Sub If there are any other suggestions i would be gratefull regards, Tempy *** Sent via Developersdex http://www.developersdex.com *** |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Find value (31.12.9999) and clear
I think you have the best (quickest and easiest anyway) solution.
Tempy wrote: Yip, i used the following: Sub RemoveWrongDate() ' Range("CA:CA").Select Selection.Replace What:="(31.12.9999)", Replacement:="", LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ ReplaceFormat:=False Range("A1").Select Columns("A:EP").EntireColumn.AutoFit End Sub If there are any other suggestions i would be gratefull regards, Tempy *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add time greater than 9999:56 | Excel Worksheet Functions | |||
| CLEAR FIND BUFFER UPON CLOSING | Excel Worksheet Functions | |||
| Replace first part of SS# with x's (XXXX-XX-9999) | Excel Programming | |||
| VBA code only working up to 9999 rows | Excel Programming | |||
| find a cell, jump to next roll and clear all cells | Excel Programming | |||
Linear Mode
