ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   remove cells with one digit (https://www.excelbanter.com/excel-programming/334859-remove-cells-one-digit.html)

Sethaholic[_15_]

remove cells with one digit
 

Hi,

How do I program vba to remove/delete the values in cells with only one
digit? I want to search through the entire workbook and to delete the
cells with one digit. Thanks


--
Sethaholic
------------------------------------------------------------------------
Sethaholic's Profile: http://www.excelforum.com/member.php...o&userid=25113
View this thread: http://www.excelforum.com/showthread...hreadid=388107


Tim Williams

remove cells with one digit
 
Only one digit means only one character and it's numeric, or mixture of
text/numbers where only one numeric character is present?

Tim

--
Tim Williams
Palo Alto, CA


"Sethaholic" wrote
in message ...

Hi,

How do I program vba to remove/delete the values in cells with only one
digit? I want to search through the entire workbook and to delete the
cells with one digit. Thanks


--
Sethaholic
------------------------------------------------------------------------
Sethaholic's Profile:

http://www.excelforum.com/member.php...o&userid=25113
View this thread: http://www.excelforum.com/showthread...hreadid=388107





All times are GMT +1. The time now is 09:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com