1. V

    RUN TIME ERROR : 13 (TYPE MISMATCH) excel debugger

    Option Explicit Sub Worksheet_SelectionChange(ByVal Target As Range) Dim ptc As PivotTable, Value As Variant, Rng As Range For Each ptc In ActiveSheet.PivotTables If Not Intersect(Target, Range(ptc.TableRange1.Address)) Is Nothing Then If Left(Target.Value, 7) = "mailto:" Then...
  2. zakasnak

    concatenate & mailto:A1

    I am using this formula to pull an email address from cell A1 : =HYPERLINK("mailto:",A1) A1 contains the formula to create the email address : =HYPERLINK(IF($X$8>0,(CONCATENATE($X$8,"")),"")) H4, the destination cell, shows the email address in the correct format & is hyperlinked...

Some videos you may like

This Week's Hot Topics