How do I get values from a hidden worksheet using VBA [closed]

As per your comment you want to loop through your range then try the below.
This is just a for loop in VBA

 sub testcode()
        dim i as double
    dim yournametofind as string
        for i = 2 to 20
        yournametofind  = Worksheets("DataValues").Range("A" & i).value
    if yournametofind = yournametofind then

    'do your things
    else

    do your things
    end if
        next i


        end sub

Browse More Popular Posts

Leave a Comment