Vb Assistance

  • Thread starter Thread starter Randy
  • Start date Start date
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.
 
Hi Mike and thank you for your assistance. Your suggestion did work but
unfortunatley did not resolve my issue. I was however, able to figure
something out that worked.

Thank you again for your response and have a wondefrul holiday season.

Best,
 
Back
Top