How to apply filter to a specific range and do stuff with it.

[TheN]

I'd like to add on to my sub by adding a filter to A6:G6 (first it should clear all filters currently applied, if any)

After that, I would like to filter out all the #N/A in the C and D columns then enter the value 'TEST' in all of the F column.

Then display everything but the #N/A values (once again, C/D columns).


In the future, should I simply record a macro and see what happens, or is it safer to simply ask here? I figure there will be more efficient answers posted here. Unfortunately, I know next to nothing about macros, still learning.

I'd also like to combine it with this macro I currently have (which should be run last) feel free to improve upon it if you see fit:

Sub InsertPageBreaks()
'reset manual breaks
  ActiveSheet.Cells.PageBreak = xlPageBreakNone
'insert breaks based on helper column
  Dim c As Range
  For Each c In Range("A1", Range("A" & Rows.Count).End(xlUp))
    If c.Offset(1).Value <> "" And c.Offset(1).Value <> c.Value Then _
      ActiveWindow.SelectedSheets.HPageBreaks.Add c.Offset(1)
  Next c
End Sub

Thanks, as always, in advance. Love how helpful everyone is.

[pjwhitfield]

In the future, should I simply record a macro and see what happens, or is it safer to simply ask here? I figure there will be more efficient answers posted here. Unfortunately, I know next to nothing about macros, still learning.

I find this is a great way for learners to get a grip of what happens with VBA, personally, this would be a far better way to do this ie try something, play around with it, get an idea of how it works and then ask a more specific question on the likes of this forum if youre still having problems.

Theres nothing unsafe about playing around with the Record Macro facility as long as youre not doing it on some live, important spreadsheet."Make a copy and play around" is my motto! (well that and "lets have another beer")

[TheN]

Yeah. I tend to save 3+ copies of everything important anyway, so if something breaks, I only have to go back so far instead of starting from scratch.

I'll have to give it a shot, and ask for syntax help, which I will inevitably need. That's basically what I was asking for, as I need to do tons more than what I said, but wanted to see an efficient way to do so. I know record macro basically records keystrokes and where you click instead of 'streamlining' the process.

Thanks though, I will give it a shot.