R
Randy
Greetings,
I have some VB Code that I am needing assistance with. Everything works
great with the exception of the 5th entry, Sheets("Commission
Pool").Range("I16").Value = Sheets("Commission Level").Range("I18")....this
entry refers to another sheet that is hidden.
I guess my question is do I need to unhide the sheet before attempting to
select the value from the hidden sheet?
Here is what I have:
If Sheets("Commission Pool").LeaseUp_Yes = True Then
Sheets("Commission Pool").Range("A6").Value = "LEASE UP"
Sheets("Commission Pool").Range("I16").Select
Selection.Locked = False
Sheets("Commission Pool").Range("I16").Value = Sheets("Commission
Level").Range("I18")
Selection.Locked = True
Else
Sheets("Commission Pool").Range("A6").Value = ""
Sheets("Commission Pool").Range("I16").Select
Selection.Locked = False
Sheets("Commission Pool").Range("I16").Value = Sheets("Commission
Level").Range("I15")
Selection.Locked = True
End If
I thank you in advance for any assistance you may be able to provide. Should
you have any questions let me know.
I have some VB Code that I am needing assistance with. Everything works
great with the exception of the 5th entry, Sheets("Commission
Pool").Range("I16").Value = Sheets("Commission Level").Range("I18")....this
entry refers to another sheet that is hidden.
I guess my question is do I need to unhide the sheet before attempting to
select the value from the hidden sheet?
Here is what I have:
If Sheets("Commission Pool").LeaseUp_Yes = True Then
Sheets("Commission Pool").Range("A6").Value = "LEASE UP"
Sheets("Commission Pool").Range("I16").Select
Selection.Locked = False
Sheets("Commission Pool").Range("I16").Value = Sheets("Commission
Level").Range("I18")
Selection.Locked = True
Else
Sheets("Commission Pool").Range("A6").Value = ""
Sheets("Commission Pool").Range("I16").Select
Selection.Locked = False
Sheets("Commission Pool").Range("I16").Value = Sheets("Commission
Level").Range("I15")
Selection.Locked = True
End If
I thank you in advance for any assistance you may be able to provide. Should
you have any questions let me know.