Hi,

Excuse me if I'm asking an idiotic question, but I've just started learning how to use macros and vba.

I have a working macro, however if used in a filtered data it will only select the visible data. I want it to disregard any filters and select everything within certain range. Searching for a solution I find many people asking the opposite - how to select only visible cells, but can't find anything on my query.

Normally, it starts like this - I want to copy everything between F:J, regardless of applied filters:

Sheets("X").Select
Columns("F:J").Select
Selection.Copy

In the end I also have an autofill which I would want to apply to all cells, including those filtered out - it's meant to autofill a formula:

Range("G2:J2").Select
Selection.AutoFill Destination:=Range("G2:J" & Range("F" & Rows.Count).End(xlUp).Row), Type:=xlFillDefault
Range("G2").Select

Thanks in advance.