range class failed

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...

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...

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...

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)...

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...

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...