Vb Assistance

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.
 
R

Randy

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top