-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
delete cell based on value
-
U
VBA Delete Cells That Contains #VALUE!
Hello Gurus, How can you delete/clear those cells that contains #VALUE! (note that it contains formula). So far I saw this code: = = = = Delete cell only If IsError(Range("C7")) Then Range("C7").Delete = = = = I have 10-15 tabs sheets and I need to run the macro like scan cells that...- unknownymous
- Thread
- #value error #value! error delete cell based on value delete cell content vba "&"
- Replies: 6
- Forum: Excel Questions
-
L
Delete invalid email address in range
Hello Gurus, Courtesy of Paelo at VBA Express i have found a VBA code (see below) that helps validating email addresses but the user is required to enter the email address manually. Sub email() Dim txtEmail As String txtEmail = InputBox("Type the address", "e-mail address")...- lricher
- Thread
- delete cell based on validation delete cell based on value delete cell with invalid email email validation function validate email address
- Replies: 1
- Forum: Excel Questions
