Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vb Assistance
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. -- Randy Street Rancho Cucamonga, CA |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then assistance... | Excel Worksheet Functions | |||
Need some assistance | Excel Worksheet Functions | |||
Assistance please? | Excel Worksheet Functions | |||
Need some assistance | Charts and Charting in Excel | |||
Assistance in VBA | Excel Programming |