Concatenate within Range Object

Navigation
0

I'm trying to concatenate a variable to a range. 

Dim i As Integer
    i = 1

    If Range("H+i") = "Validacion Expediente" Then
        MsgBox ("y") 
    Else   
        MsgBox ("N")

this in order to know if the cells that are in column H have the name File Validation.

    
asked by ARR 15.06.2018 в 17:11
source

1 answer

0

I have already solved the problem, the answer is: 

Dim i As Integer
i = 1

If Range("H" & i) = "Validacion Expediente" Then
    MsgBox ("y") 
Else  
    MsgBox ("N")
    
answered by 15.06.2018 / 17:19
source
Error starting a project in laravel from localhost Do not open sweet alert