error check for select case target.address

  • I have used the code below to copy a cell value to the linked cell of a combobox (this code is an excerp of about 60 cases)


    the problem is that the cell value being copied contains a formula such as
    =IF(ISTEXT(Properties!AF8), HYPERLINK("#geninfopage", Properties!AH8), IF(ISTEXT(Properties!AK8), HYPERLINK("#geninfopage", Properties!AL8), ""))
    which can result in the blank cell depending upon whether a search gives a result. If a blank cell is copied to the linked cell of the combo box an error results.


    what I would like to build in is a error check to identify if a cell is empty before executing the code (or not executing)
    eg
    if worksheets("frontend").range("C11").value <> ""
    then execute
    else do nothing



    Thankyou for any help
    Justin

  • Re: error check for select case target.address


    Hi Justin


    Fill in the blanks below