Determine Name of a Cell

[BRich83]

I have a number of cells named on a worksheet, and I want to run code that is variable based on the cell's name. Is there a way to determine what the cell's assigned name is? I already know how to define a cell's name, but I can't figure out how to read what it is.

I'm looking for something like this:

box = Cells(rw, cl).Name

Basically I want the macro to recognize where it is on a sheet, and then check the surrounding cells based on the name of the cell.

 

[VoG]

Try

box = Cells(rw, cl).Name.Name

 

[BRich83]

Perfect! That seems like a silly way to do it, and I never would have tried that. Thanks.

 

[VoG]

Me, silly

 

[BRich83]

Ok, now I'm trying to call a new cells using what you just gave me and search for values, but I'm getting a type mismatch.

                'Guesses a number and checks box, col, and row
        For numguess = 1 To 9
        'Searches box
        bxnum = Mid(Cells(rw, cl).Name.Name, 4, 1) 'number of current box
        For i = 1 To 9
            If Cells("box" & bxnum & i).Value = numguess Then
                GoTo SkipNum
            End If
        Next i

bxnum refers to which box I'm currently in with an integer. I now want to search all 8 other cells in the area labeled "Box1x" with x being 1-9. It doesn't like how I'm trying to refer to the cell, but I thought you could call it by name. Ideas?

 

[VoG]

I'm not sure if this will work but try Range() instead of Cells()

 

[BRich83]

Two easy questions, two easy answers. I feel dumb for that last one, I've used that before. Thank you again.