Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
range names in macros - syntax again
I have some macro code that hides a certain range of rows (220 to 228).
However, occasionally, a few rows get added in the middle, which messes up the macro. I think I know that, if I name the range (I did as "net.profit.rows.on.ProjectCF" though the macro keeps changing some of the letters to upper case), and use the range name in the macro, it will adjust for such changes automatically. The first row of code works fine. The second one, my feeble attempt at the aforementioned fix, doesn't. Please tell me how to get this range name to be hidden, in the Else condition. If I need to dimension something too, let me know, please. Thx. Dean If ProfitMode = "Net Profit %" Then Rows("160:208").Hidden = True Else Rows("200:228").Hidden = True If ProfitMode = "Net Profit %" Then Rows("160:208").Hidden = True Else net.profit.Rows.On.ProjectCF.Hidden = True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
version differences in excel 2007 - use of macros & range names | Excel Discussion (Misc queries) | |||
Range names in macros - DA | Excel Programming | |||
Range names in a Excell macros | Excel Programming | |||
Syntax in Varying Object Names | Excel Programming | |||
Names.Add - Range Syntax Issue | Excel Programming |