i want to have macro enabled drop downs in all rows...

[Legend Rubber]

I have this... (with a few more lines as well)

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$A$20" Then
Select Case Target.Value
Case "000-101-7221"
Call Macro000_101_7221
Case "000-101-7521"
Call Macro000_101_7521
Case "000-101-7621"
Call Macro000_101_7621
Case "000-111-7521"
End Select
End If
End Sub

But what i want is to make this same code work for all rows, A20 to A45...
Copy 2 of Packing Slip.xlsm

VERY beginner at VBA... try to use easy terms

[dilipandey]

Hi Legend Rubber,

Welcome to the forum.

Please do not post duplicate threads.. another one is :-
http://www.excelforum.com/excel-prog...tml?highlight=

Regards,
DILIPandey

<click on below 'star' if this helps>

[zbor]

Thank you DP.
Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.