filter table vba

  1. N

    Pasting a filtered table with a Macro

    I need some help with a macro. I created an event where a cell is changed and thus updates the table by filtering with the number that gets updated- this part works fine. The problem I'm having is that the macro I created is supposed to copy the filtered information and paste it into a new...
  2. B

    Identify first row of filtered table

    I have a table that has been filterers on the basis of this code; ActiveSheet.Range("$AG$18:$AG$100").AutoFilter Field:=1, Criteria1:= _ "Requires Attention" The header is row 18. I know the first and last columns and I have the code that will identify the last row. All I need it...
  3. B

    how do i

    <TABLE style="WIDTH: 96pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=128 x:str><COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: #ece9d8; BACKGROUND-COLOR: transparent...
  4. J

    How to keep only the filtered results

    Most of my VBA scripts are modified results of the macro recorder, so I often use inelegant workarounds, though I suspect there are better solutions out there. One such workaround is how to keep only the results of a filter. I currently apply the filter, select all cells, add a sheet, and paste...
  5. O

    How to query a range

    I have a range called movie with field names in the first row. It looks like this: movienum title rating 1 batman R 2 superman R 3 wonderwoman PG How can I return an array of only the records that will...

Some videos you may like

This Week's Hot Topics