There are 5 different fee structure in my worksheet.
Why is it that the FeeSt value is empty? If the Cell in Row 2, Column 1 contains the value "Split Fee", shouldn't the FeeSt value be "Split Fee"?
Sub feestructure() Dim FeeSt As String For X = 2 To 6 Worksheets("Customer Reference").Range("A" & X).Value = FeeSt 'Blah blah do something Next End Sub
Bookmarks