duplicates code works in one sheet but not another?

[ferday]

i have the following code (snippet), it takes a block of duplicate values (x) for which there may be 1 or thousands, and then averages the corresponding value (V) in column C, then prints that average value out to another range:

Please Login or Register  to view this content.

this is working for me just fine on one workbook, but the same exact code isn't working at all on another! the cells just stay blank, nothing happens at all

EDIT:
ok i've figured out that the only difference is that one book is importing a .csv, and the other is pasting data...so now to figure out how to force a .csv into excel data!

[newdoverman]

It appears to me that you haven't included the whole code in your snippet. The code should start with something like "Sub...." or "Public Function ...." something along those lines and then end with "End Sub" or "End Function". The End part will match the beginning Sub or Public depending upon how the code starts.

[ferday]

it's a portion from the middle, forgot to add it to the code to make it easy for anyone.

i've figured out the problem - somewhat. i am importing a .csv file in the new book, the old book was pasting from an excel file. if i paste into the new book, the code is working fine...so the problem is that for some reason the .csv import is making the data unusable.

i'm trying some things now to see if i can somehow modify the .csv data

[newdoverman]

Check what should be numeric values in the CSV import. Perhaps they are text values that the code can't read.