Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for text
I sort my data which is a combination of numbers and text, via a macro so
that the numbers are first. What I would like to do is delete out all cells which contain text. What I cant figure out how to test for the first row without a number in column A so I can delete out all rows after that one. Can anyone help? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Testing for text
Edgar,
Use the IsNumber Function to test the cell value. -- HTH RP "Edgar Thoemmes" wrote in message ... I sort my data which is a combination of numbers and text, via a macro so that the numbers are first. What I would like to do is delete out all cells which contain text. What I cant figure out how to test for the first row without a number in column A so I can delete out all rows after that one. Can anyone help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User form - Testing for numbers or text | Excel Discussion (Misc queries) | |||
TESTING | Excel Worksheet Functions | |||
Testing | Excel Discussion (Misc queries) | |||
just testing | Excel Programming | |||
Testing for text | Excel Programming |