selection.autofilter

  1. H

    More Than 2 Criteria

    hi I recorded 3 macros so I could see the code for each and hopefully compile something which will filter for all 3, as the standard Excel filter will only allow for 2. I am trying to filter to only leave rows with a zero, a blank or that are >=30 The code for code for each came up as...
  2. earthworm

    Loop help required to run another macro

    I have numeric values in another sheet by the name of summary. If cell value in summary sheet example F5 is > 0 or less then 0 or <> 0 only then i want to run the macro for that particular company . The problem is if i use if condition it stop running the second macro if the first value is...
  3. S

    Data loss when deleting filtered rows

    Hi all, I've got a macro which appeared to be working perfectly, however when I ran the data without any of the products to be excluded I found that I was losing EVERYTHING :confused: I've narrowed the culprit down to this: 'Remove excluded products Sheets("Consolidated").Select...
  4. R

    Vba to name a active cells in a column

    :) Hi all, I have the following code which will filter the columns as per my requirement but after filtering the columns i need to name the active cells as "Ship" in the column "Remarks" based on the used range column A. Please assist. <code style="margin: 0px; padding: 0px; font-style...
  5. P

    Autofilter Arrows showing

    Hi there I have done a macro that filters the whole worksheet. Then I did another macro that unfilters it. The code "Selection.Autofilter" Unfilters the worksheet. But I want to get rid of those pesky dropdown arrows every time I run the code. I tried the following code, but I got an error...
  6. T

    Delete all rows VBA

    Hi Guys, Is there a way to delete all the rows int he selected autofilter in the below code. At the moment it only looks as rows 2:29. Thanks Sub Macro1() ActiveSheet.ListObjects("Brecon_Mail_Merge").Range.AutoFilter Field:=12, _ Criteria1:="Non Ford" Rows("2:29").Select...
  7. T

    Find name in column and copy to relevant worksheet

    Hi Guys, I have a list of data with a persons name in column N. For each person i have created a tab which is identical to their name in column N. Is there a way to filter by that person and copy all of the data to the relevant named tab as values. At the moment i am doing the below but...
  8. M

    How to edit Macro to ensure print area and streamline

    I have been growing more and more comfortable with Excel in my new position and really enjoy learning how to work more efficiently with it. Recently I have been filling in for someone on long term disability and I have to extract data from AVANTIS to an existing Macro every week that we use to...
  9. P

    How to handle Error 1004 in Autofilter Multiple Criteria

    Hi Guys - I have this code. The 2nd part fails (Doesn't move to EFCFilter on error) whenever there is no matching filter criteria in 1st part. But, runs perfectly if there is matching filter criteria found in 1st part. Any thought? '--------------------------1st...
  10. R

    Script will not paste on Macro3

    I have created a spreadsheet that pulls all data as required but when the code runs to Macro3, it gets hung up and will not paste into my sheet. If someone can tell me what I could use to make this work for a paste of the tab named what is in cell N16, I would appreciate it... The process runs...
  11. R

    Call Worksheet name from user input field???

    For the following script, I have one issue where I need to ask the user for the month in cell N16 as there is no logical way to figure out the correct tab without user input. So for the line in Macro 3 listed as Worksheets("July 2018").Activate, I need assistance on pulling the Worksheet name...
  12. D

    VBA code for autofill until empty

    Hi All, Can you please help me by adjusting this VBA for autofill until empty for the following ranges? ActiveSheet.Range("$B$1:$N$115326") Selection.AutoFill Destination:=Range("A2:A115324") Thank you very much!!! P.S. See VBA...
  13. H

    convert VBA to vb.net or VB6

    I have a simple module that calls a form to allow the user to select a row that sets a header filter and colors. I am trying to figure out how to convert this to vb.net or vb6 so it can be compiled. All the documentation I found is from 2005 visual studio and it doesn't work in visual studio...
  14. P

    Find and Replace Code to Multiple Subs

    Hi can anyone help with replacing the lines in RED with the lines in Blue to multiple subs? Sub dups1() Sheets("Sheet11").Select Dim Sheet11 As Worksheet: Set Sheet11 = Sheet11 Dim lRow As Long lRow = Sheet11.Cells(Rows.Count, "A").End(xlUp).Row Range("A1:BD" &...
  15. earthworm

    Macro to dynamically copy new data and delete data from dynamic height

    I am trying to create dynamic macro if the data set does not contain the value Rizwan then copy paste it somewhere else , and then remove the data containing Rizwan from the source data . the height of data can vary and sequence is also not guranteed. how to make the macro dynamic i tried...
  16. R

    what have i done wrong

    what have i done wrong the first time it run it errors the second time it works Sub pitchers() Cells.Select Selection.AutoFilter ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.clear ActiveWorkbook.Worksheets("Sheet1").AutoFilter.Sort.SortFields.Add Key:=Range _...
  17. H

    Vba - autofilter and save as image

    Hi friends, I need a macro to auto filter and save the result as an image. Would you please help me? I found this code but it "prints" the result i need to save the result as an image. Sub Auto_Print_Lamp_PK() Dim noDupes As New Collection Dim rw As Long Dim itm As Variant...
  18. C

    Stopping an Autofilter macro if no value is found...

    This code searches for a criteria value catval between the given dates d1 & d2: Range("A1:E1").Select Selection.AutoFilter With Sheets("REGISTER").Range("B1").CurrentRegion.Offset(1, 0) .AutoFilter Field:=2, Criteria1:=catval .AutoFilter Field:=3, Criteria1:=">=" & d1...
  19. G

    Old macro cannot change first row headings

    I am not very knowledgeable about macros but the company I have just started working for has a few it uses to make reports out of the system more useable quickly. However, there is one that is broken and seems far too complex for me to fix so I am trying to copy another macro to at least...
  20. crystalneedshelpplzthnx

    Inserting a formula not working correctly

    Hi All, I have been searching and changing this code and nothing has worked. I have been running the code after copying the formula as a work around. Can anyone explain what it is I am doing incorrectly. Ive tried the following: Sub Key_Items_Validation1() Sheets("ProductivityData MTD").Select...

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
Back
Top