range class failed

  1. A

    VBA TO EXCLUDE CURRENT MONTH

    Hi, Very new to VBA and struggling. Any help would be very much appreciated. Thank you. I have a workbook with several worksheets that I want to filter all at once to exclude the current month. Data is in tables with date in Column Q. Date is in dd/mm/yyyy format I am getting a "AutoFilter...
  2. szita2000

    VBA Error 1004 - CopyPicture method of Range class failed

    Hi all. I am trying to run the following code one after another for three different ranges. The macro extracts the ranges and save them as pictures. Sub ExportBRRangeToPNG() '--exports selected range to png file ' jpg is not appropriate format for this output ' default filename is...
  3. M

    Runtime Error 1004 - Active method of range class failed - multiple sheets

    Good evening all, I've had a read through various posts but due to my lack of knowledge, it is difficult to determine if others are have the same runtime error as me or not. If anyone has any suggestions, I'd be grateful. I have a workbook, that originally contained just the one sheet. The...
  4. P

    Range problem

    Dear Team! Finally I have only a very short test code to test range (for copy). I tried R1C1 and the original style but the range object doesn't work. "Method "range" of Object '_global' failed" (1004) or (I used "A1" as well) "object variable or with block variable not set" (91) and (somehow)...
  5. M

    Delete Non-Contiguous Rows, Excel VBA

    I have a spreadsheet that users can only modify through userforms. One userform is meant to allow users to select entire rows of the spreadsheet and delete the data. My current code works when one row is selected or when one contiguous block of rows is selected, but fails when several non...
  6. H

    Delete Method of Range Failed... But it works?

    Hello, So... I've been working at this for quite a while. I think the code needs a closing statement for the for, but I'm not sure. When the error produces ".EntireRow.Delete" is highlighted; however, it still deleted the rows correctly. I'm trying to make this template neat, so it works, but...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top