Property of a cell with a string

  • Thread starter Thread starter Slim Slender
  • Start date Start date
S

Slim Slender

If .Cells(myRow, myColumn).???? = "String"
Then

What property of cells do I need here? Value gives an error.
Auto List Members, List properties/Methods won't work for me. They are
turned on in Options but I can't get any help.
 
After serious thinking Slim Slender wrote :
If .Cells(myRow, myColumn).???? = "String"
Then

What property of cells do I need here? Value gives an error.
Auto List Members, List properties/Methods won't work for me. They are
turned on in Options but I can't get any help.
Click to expand...

..Value is default; .Text may be an option; -neither are needed here!

Try using a var to put the cell contents into, then test the var.

Dim vTemp As Variant

'Get the cell contents
vTemp = Cells(myRow, myColumn)

'Test the cell contents
If vTemp = "String" Then...
 
Try this with text in B5 and with a number in B5 Then run it with and without ".Value"
....
Don't place any bets ahead of time. <g>
'---
Sub xyz()
Dim myType As String
myType = TypeName(Cells(5, 2).Value)

If myType = "String" Then
MsgBox myType
Else
MsgBox "Not a string, it is a " & myType
End If
End Sub
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(Extras for Excel add-in: convenience built-in)





"Slim Slender" <[email protected]>
wrote in message
news:9d798d8e-2d4c-455e-a56c-92ed548e676e@v17g2000vbo.googlegroups.com...
 
Thanks for the responses. Turned out all I had to do was specify the
column.

If .Cells(myRow, myColumn).Value = "String" Then doesn't
work, but

If .Cells(myRow, 5).Value = "String" Then works just
fine.

This is what I wanted in the first place but I was working with cloned
code
and hadn't completely adapted it.
 
Back
Top