PDA

View Full Version : Solved: Range("FilterArea")



KevinPhilips
07-22-2013, 05:12 AM
Hi all,

I do not understand what happens in these 2 lines of code:

Range("FilterArea").Select
On Error Resume Next

I did try to google it, without success. Hopefully someone is willing and able to help and explain.

Thank you guys in advance!

Jomathr
07-25-2013, 06:46 PM
Well there isn't much going on there,

Basically the first line Range("FilterArea").Select is to select a named ranged in excel, to check what it refers to, go to the formula tab then name manager in the Defined names group then find FilterArea in the list.
As for the second line it would tell vba to ignore an empty reference in this case

Cheers