Data validation list, autofill to last row

[muss1210]

Hello Forum

I have the below code which works on it's own, but if i run the code from a button i get a runtime error1004 which i presume is where it tries to autofill the dropdownlists to the last row as it creates the data in cell I2

Please Login or Register  to view this content.

This code i also have to have in it's own sub for some unknown reason as when i put it with the rest of my code i get the same runtime error but with the message "autofill method of range class failed"

Please Login or Register  to view this content.

Thanks in advance

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.

[salim ali]

Try this Macro

Please Login or Register  to view this content.