VBA Table from Spreadsheet Range

B

BillCPA

In VBA, I need to take a value and look it up in a range on a spreadsheet.
Is it better to actually access the cells on the spreadsheet or load the
range into a VBA variable? If using a variable is best, what is the best way
to load and use the data?
 
B

BrianB

I don't see any need to waste time on an intermediate process. Accessing
sheets directly is very fast and easy to code.
 
Top