In article ,
"Sam via OfficeKB.com" wrote:

However, I'm not sure why it is
not returning all the consecutive values on the 2nd Sheet for the first two
columns. I should see 9 values in columns "B" and "C"
that are consecutive.

Would you like me to take a look at a sample of your file and see if I
can pinpoint the problem? If so, you can email me at
. Otherwise, I can email you a sample file.