Code needs to Clear old data then Update specified Ranges when Value in Drop down is Chang

[Aeneren]

Hello All, Code needs to Clear old data then Update specified Ranges when Value in Drop down is Chang

Needing the following code altered if possible so that when Drop Down list value is changed the Code will Clear all Data from Main Gear starting at B:R44 and down 2, 4, 20 how ever many lines of data there are, and then place the new data in

Please Login or Register  to view this content.

Thanks Again,
Aeneren

[JLGWhiz]

See if this works for you

Please Login or Register  to view this content.

[Aeneren]

JLGWhiz,

Getting a: Run Time error '9' Subscript of of Range

Please Login or Register  to view this content.

Aeneren

[JLGWhiz]

JLGWhiz,

Getting a: Run Time error '9' Subscript of of Range

Please Login or Register  to view this content.

Aeneren

If Range B1 of Main Gear is blank, it might cause the error.

[JLGWhiz]

Never mind, the problem is xlRow should be xlRows.

[Aeneren]

JLGWhiz,

Ok the Clear and update is working with the following Corrections:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Now i need it to update itself when the Drop down box contents are changed, as it is now the Range only updates if i change tabs and then go back to Main Gear


Aeneren

[JLGWhiz]

Which cells contain a drop down that the user might click on?

[JLGWhiz]

If B42 is the cell with the drop down then this should work.

Please Login or Register  to view this content.

[Aeneren]

JLGWhiz,

Thanks Again that is working Great.

Rep added



Thanks Again
Aeneren