Solved

Range of boject-worksheet failed

Posted on 2013-10-22
4
154 Views
Last Modified: 2013-10-22
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
Comment
Question by:Frank Freese
  • 3
4 Comments
 
LVL 19

Accepted Solution

by:
Ken Butters earned 500 total points
ID: 39591979
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
 

Author Comment

by:Frank Freese
ID: 39592021
OK folks - I think I foundthe error of my ways
Range(A8) needs to be Range ("A8")
0
 

Author Comment

by:Frank Freese
ID: 39592036
I've requested that this question be deleted for the following reason:

Saw what I did wrong and resolved it myself
0
 

Author Closing Comment

by:Frank Freese
ID: 39592037
thanks - I came to the same conclusion
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question