in this code, my form only works with the one sheet... how do i make it work with whatever sheet I have selected or is active?
Private Sub cmdADD_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("1999 Upper Deck")
I have several worksheets that require the same info.... card number...quantity..player name.. I have a different sheet for each year and brand in my collection. I really dont want to make a form for each one of these sheets..... how do i change my code to make it input the data into the sheet I have seleced
Bookmarks