Help : Code to assign speeds in speed bins

[Uzzgee]

Hi everyone...

Hope you's are all well.

Can anyone assist with this piece of code that I have tried to "Adjust/Manipulate" to work with speed bins ? ( My attempt Attached).... cant seem to see where i have gone wrong ( i have limited knowledge of codeing).

Basically i have an excel sheet which contains a column with the Exact Speed and i need it to categorise the values into set Speed Bins ( There are over 10k records).

Hope someone can assist, any further questions then please feel free to ask.

Thanks

Gee

[nathansav]

you are referencing a variable value, which isnt defined, try

if Cells(intRow, strCol).Value < 16


etc.

[Miroslav R.]

Hi there,
Your code miss '=' sign:

Please Login or Register  to view this content.

should be:

Please Login or Register  to view this content.

like in first category.

Also I miss a range everywhere the 'value' stands alone:

Please Login or Register  to view this content.

should be written:

Please Login or Register  to view this content.

(When You click in macro, hit F8 to debug line by line and You will se where all the errors are. Or go to menu in VBA-> Debug->Compile VBAProject)

[Uzzgee]

Hi Miroslav,

Thanks for your detailed responce.

I have made the changes you have requested ( updated sheet attached) and tried the debug but it is still stopping at the 1st line ...

Can you provide further assistance / help ?

Many thanks

Gee

[Miroslav R.]

Hi there,
instad of posting .txt files, can You upload excel workbook? So I can test it on real data source...

[nathansav]

inputbox returns string type and you're passing into long. Try Clng(inputbox.....)