View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
x taol x taol is offline
external usenet poster
 
Posts: 101
Default 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 ***