Here is the code that is not working:
' If IsEmpty(Range("D3")) then msgbox("error") GoTo Ex end if
' Range("A6:I6").Insert Shift:=xlDown
What I want to do is verify that the user has entered data before performing the Range commands. If the cell D3 is blank I wish to display a Msgbox warning and then Exit the routine before the Range commands are processed. Thought I could accomplish this with the Msgbox and the GoTo but something is wrong with syntax. Appreciate any suggestions.
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…