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 Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
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…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…