Search:

Type: Posts; User: Ervis

Search: Search took 0.02 seconds.

  1. Re: Method 'Range' of object '_Worksheet' failed

    Thank you guys. I solved :)
  2. Re: Method 'Range' of object '_Worksheet' failed

    I forgot to write application.enableevents = true at the end. There is any way to do it manually now?
  3. Re: Method 'Range' of object '_Worksheet' failed

    I typed it wrong the code involves two different sheets:

    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Worksheets("Sheet1").Range("B1") = 1 Then...
  4. [RESOLVED] Method 'Range' of object '_Worksheet' failed

    Hello, I am trying to implement this simple code in VBA:

    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
    If Worksheets("InputOutputArena").Range("B1") = 1 Then...
Results 1 to 4 of 4



Click Here to Expand Forum to Full Width