Here is an example that reads one block of text from anywhere on the specified sheet. This text could be converted to numbers or you can change the string array to a numeric array.
Be sure to close all references after use, otherwise Excel will hang later on.
Michael Munroe
www.abcdef.biz