Search:

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

Search: Search took 0.00 seconds.

  1. Re: Delete rows if cells value, across all worksheets!?

    It happens not matter what sheet I'm on, but now it doesn't even apply the filter or do anything, just shows that error
  2. Re: Delete rows if cells value, across all worksheets!?

    ws.ShowAllData
  3. Re: Delete rows if cells value, across all worksheets!?

    I must be getting on your nerves, so sorry!

    But I'm getting a different error now;

    Run-time error'1004':
    Method 'showAllData' of object '_Worksheet' failed
  4. Re: Delete rows if cells value, across all worksheets!?

    Yes, I've just remembered the tables are named, this wouldn't cause an issue would it?
  5. Re: Delete rows if cells value, across all worksheets!?

    The value I've used as test exists multiple times across two separate sheets. It finds and deletes the lines if I manually look afterwards but can't seem to remove the autofilter after this
  6. Re: Delete rows if cells value, across all worksheets!?

    Hello again!

    Sorry about the late reply, I've been in and out of the office!

    No merged cells, and yes A1 is the header and A2 downwards is the start of the data

    Thanks,
    Zac
  7. Re: Delete rows if cells value, across all worksheets!?

    Hi there!

    Sorry for the late reply, please see error below!

    Run-time error '91';

    Object variable or With block variable not set

    Thanks,
    Zac
  8. Re: Delete rows if cells value, across all worksheets!?

    Hi and thanks again!

    It is running and deleting the data from one work sheet but showing an error when it tries to remove the filter :( and the yellow fault line is on the .delete row on VBA

    Zac
  9. Re: Delete rows if cells value, across all worksheets!?

    Hi!

    Thank for the fast response! It will be exact values I will manually edit in the macro. I would like to do it in a data range in the future so less capable bodies could edit, though i'll...
  10. Delete rows if cells value, across all worksheets!?

    Hi All,

    I've gotten myself in a right mess, sulked like a child and deleted all my work!

    What I would like is the main body of a macro which I will hopefully adjust to what I need and I can...
Results 1 to 10 of 10