200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
If wsh3.Range("A2") = "" ThenActually i writed the code but it is not working perfect for me & So plz help in solving this Problem
Hi Sir/Mam
My condition-If wsh3.Range A2 cell does not have a single Alphabets in A2 cell Then (A2 cell may have Numbers Or Special Characters Or anything in it But we have to look for Alphabets in A2 cell )
Plz help me in making the perfect line for my condition
Rider
If you want to detect whene A2 of your .csv does NOT contain any alphabetic characters, use:
If Not wsh3.Range("A2").Value Like "*[a-zA-Z]*" ThenThis would be TRUE for "123" in A2 of your .csv file or an empty cell.but FALSE for "Excel123".
Omit the Not is you want to detect when it DOES contain alphabetic characters (or work with the Else statement after the test above).
Note that you can detect empty cells using the VBA's LEN function. That returns the number of characters in a cell e.g. "123" would give 3 but any empty cell gives 0, even in a .csv file (where an "empty" may contain special characters). Use:
If Len(wsh3.Range("A2").Value) = 0 ThenHope this helps.
If wsh3.Range("A2").Value <> doesn't have Alphabets with anything Or anything with Alphabets Then