getting the entire range before be filtered
 

for example, set [a1:d100] of entire range, filtering
the result, filtered range is setting

And then, Directly I want to get entire range address using macro.
i don't want to get using 'showalldata' or 'filtermode=false'



*** Sent via Developersdex http://www.developersdex.com ***