[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

Range of boject-worksheet failed

Folks,
In the below code at the very first line I am getting this error:
Method 'Range of Object_worksheet failed.
Private Sub cmdCheckTDT_Click()
If Range(A8).Text = "Football game: Tyle vs Winston starts 16.10.2013 exactly at 16:00 !!" Then
    Range("A7").Locked = False
    Range("A7").Font.Color = vbWhite
    Range("A7").Interior.Color = vbRed
    Range("A7").Value = "Correct"
    
Else
    Range("A7").Value = "Error"
    Range("A7").Font.Color = vbYellow
    Range("A7").Interior.Color = vbBlack
    Range("A7").Locked = True
    CheckFormulaFunction
    Exit Sub
End If
FormulasOK

End Sub

Open in new window

Here's the code in A8:
=B4 & " starts " & TEXT(B5,"DD.MM.YYYY") & " exactly at " & TEXT(B6,"hh:mm") & " !!"

Open in new window


I'm simply trying to pull what's in A8 to what should be in A8 and that determines what happens next.
0
Frank Freese
Asked:
Frank Freese
  • 3
1 Solution
 
Ken ButtersCommented:
try putting A8 in double quotes.

If that doesn't work you may need to more explicity identify the range you are referring to...

example : thisWorkbook.sheets("Sheet1").Range("A8")
0
 
Frank FreeseAuthor Commented:
OK folks - I think I foundthe error of my ways
Range(A8) needs to be Range ("A8")
0
 
Frank FreeseAuthor Commented:
I've requested that this question be deleted for the following reason:

Saw what I did wrong and resolved it myself
0
 
Frank FreeseAuthor Commented:
thanks - I came to the same conclusion
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now