Thread: MS Excel wizz's Is there a script for?
View Single Post
  #7  
Old 04-23-2009, 08:18 PM
brizzo's Avatar
brizzo brizzo is offline
Member
  
Join Date: Apr 2006
Location: Kelowna BC
Posts: 504
brizzo is on a distinguished road
Default
Quote:
Originally Posted by Glennrf38 View Post
Nazarine. You almost have it. change the ranges from $A$1:$B:$B1000 to just A$:B$
It actually makes the vlookup a bit faster. Other than that I agree. I think that is the best way unless he goes with VBA. Depending on what he is looking for.
Nice!! I was always wondering if there was a better way than a specific table range. That tip will help with some of my dynamic sheets that have data pulled from a database.
__________________
28g Nano Cube drilled with 13g sump in stock stand. Vertex IN80 Skimmer, Phosban 150 Reactor, Apex Controller, DIY LED with stock hood, dimmable
Established March 2006
Reply With Quote