Avatar of Tom Black
Tom Black
Flag for United States of America

asked on 

Assign a value in Excel V-Basic

I assigned a name to a merged cell

    With Report.Range("C8:H8")
        .Name = "Location"
    End With
    Range("Location").Value = "Multiple (see below)"

I need to use the value entered to trigger additional code.
Dim Choice as String
    Choice = Report.Range("Location").Value
I keep getting a type mismatch error.

Any help would be appreciated
Microsoft OfficeMicrosoft ExcelVBA

Avatar of undefined
Last Comment
Tom Black

8/22/2022 - Mon