Search:

Type: Posts; User: rob_grimshaw; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: Intersect(Target, TargetField) run-time error (1004)

    Thanks
  2. Re: Intersect(Target, TargetField) run-time error (1004)

    Thanks for this.

    For my learning, what was the problem with the original code?
  3. Re: Intersect(Target, TargetField) run-time error (1004)

    Yes, absolutely.
  4. Re: Intersect(Target, TargetField) run-time error (1004)

    The debugger highlights the first "
    If Not Intersect(Target, TargetField) Is Nothing Then"
    but working through the code I believe that the error is caused at
    "
    SourceField.Offset(, 29) =...
  5. Intersect(Target, TargetField) run-time error (1004)

    Dear all,

    I am getting a run-time error for this code, can you help tell me why and how to fix it?




    Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

    ...
  6. Replies
    5
    Views
    173

    Re: VBA variable error

    Could an option be to colour each cell yellow (for example) and then with a different line of code delete every yellow cell?
  7. Replies
    5
    Views
    173

    Re: VBA variable error

    I have a dataset in column A. I want the VBA to compare this to a predefined list contained in another spreadsheet (exclusion criteria). If the data in column A is present in the exclusion criteria...
  8. Replies
    5
    Views
    173

    VBA variable error

    Dear all,

    I've written some VBA code to

    find a value in another spreadsheet and
    where that value occurs delete the row in the original

    However, I keep getting an "Object variable or With...
Results 1 to 8 of 8