Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vb Assistance
Hi,
You won't have an issue reading from a hidden sheet so your problem lies elsewhere. What is this line supposed to do, is it referring to a named range? If Sheets("Commission Pool").LeaseUp_Yes = True Then If it is then you can use this and with this change your code worked for me If Sheets("Commission Pool").Range("LeaseUp_Yes") Then Mike "Randy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum and If Assistance Please | Excel Worksheet Functions | |||
Need some assistance | Charts and Charting in Excel | |||
I Need VBA Assistance for EOF | Excel Discussion (Misc queries) | |||
Assistance in VBA | Excel Programming | |||
I need assistance please | Excel Programming |