I have a financial summary and depending on the selections some rows are always going to have $0 values. I need an Applescript that will mimic VBA code that will automatically run each time the worksheet recalculates that will hide a row with all $0 values in columns B through F. It affects a total of five rows and they all operate on different conditions, but the rule would apply to all of them if the sum of columns B through F for the row = $0. Any help would be appreciated. I am only starting to work with code and have never taken any courses so if you would not mind I would get a lot more out of it with a simple explanation of how it works or a reference to review it. Thank you in advance. Joe Frustrated in Baltimore
Joe Gardill wrote: > I have a financial summary and depending on the selections some rows are > always going to have $0 values. > > I need an Applescript that will mimic VBA code that will automatically run > each time the worksheet recalculates that will hide a row with all $0 values > in columns B through F. > It affects a total of five rows and they all operate on different > conditions, but the rule would apply to all of them if the sum of columns B > through F for the row = $0. > > Any help would be appreciated. I am only starting to work with code and have > never taken any courses so if you would not mind I would get a lot more out > of it with a simple explanation of how it works or a reference to review it. Hi Joe! FYI, this newsgroup has been deprecated and replaced with microsoft.public.mac.office. Be sure to post any further questions in that group rather than this one. You'll have a lot more eyes seeing your messages there. Your problem sounds like it's about Excel. I'm copying that group on this message and setting all follow ups to this message to appear there. You can find it in microsoft.public.mac.office.excel. Good luck finding your answer! -- bill Entourage Help Page <http://entourage.mvps.org/> Entourage Help Blog <http://blog.entourage.mvps.org/> YouTalk <http://nine.pairlist.net/mailman/listinfo/youtalk> Twitter: follow <http://twitter.com/meck>
William Smith [MVP] wrote: > Joe Gardill wrote: > >> I have a financial summary and depending on the selections some rows are >> always going to have $0 values. >> >> I need an Applescript that will mimic VBA code that will automatically >> run >> each time the worksheet recalculates that will hide a row with all $0 >> values >> in columns B through F. >> It affects a total of five rows and they all operate on different >> conditions, but the rule would apply to all of them if the sum of >> columns B >> through F for the row = $0. >> >> Any help would be appreciated. I am only starting to work with code >> and have >> never taken any courses so if you would not mind I would get a lot >> more out >> of it with a simple explanation of how it works or a reference to >> review it. > > Hi Joe! > > FYI, this newsgroup has been deprecated and replaced with > microsoft.public.mac.office. Be sure to post any further questions in > that group rather than this one. You'll have a lot more eyes seeing your > messages there. > > Your problem sounds like it's about Excel. I'm copying that group on > this message and setting all follow ups to this message to appear there. > You can find it in microsoft.public.mac.office.excel. > > Good luck finding your answer! > Hi Joe, What version of Excel are you using? Is the reason you need an AppleScript because you are using Excel 2008, or is there a different reason? -Jim -- Jim Gordon Mac MVP MVPs are independent experts who are not affiliated with Microsoft. http://mvp.support.microsoft.com/ Visit my blog http://blog.360.yahoo.com/blog-i7JMeio7cqvhotIUwCzaJWq9
Yes, I use Excel 2008 and that is the only reason I need to create this in AppleScript. On 8/30/08 12:15 PM, in article erxbrurCJHA.4340@TK2MSFTNGP02.phx.gbl, "Jim Gordon MVP" wrote: > William Smith [MVP] wrote: >> Joe Gardill wrote: >> >>> I have a financial summary and depending on the selections some rows are >>> always going to have $0 values. >>> >>> I need an Applescript that will mimic VBA code that will automatically >>> run >>> each time the worksheet recalculates that will hide a row with all $0 >>> values >>> in columns B through F. >>> It affects a total of five rows and they all operate on different >>> conditions, but the rule would apply to all of them if the sum of >>> columns B >>> through F for the row = $0. >>> >>> Any help would be appreciated. I am only starting to work with code >>> and have >>> never taken any courses so if you would not mind I would get a lot >>> more out >>> of it with a simple explanation of how it works or a reference to >>> review it. >> >> Hi Joe! >> >> FYI, this newsgroup has been deprecated and replaced with >> microsoft.public.mac.office. Be sure to post any further questions in >> that group rather than this one. You'll have a lot more eyes seeing your >> messages there. >> >> Your problem sounds like it's about Excel. I'm copying that group on >> this message and setting all follow ups to this message to appear there. >> You can find it in microsoft.public.mac.office.excel. >> >> Good luck finding your answer! >> > > Hi Joe, > > What version of Excel are you using? Is the reason you need an > AppleScript because you are using Excel 2008, or is there a different > reason? > > -Jim
