In addition Shift+F9 will calculate only the Active Sheet. --- *Sixthsense **:) Man of Extreme & Innovative Thoughts :)*
On Tue, May 31, 2011 at 10:22 AM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > F9 Only Calculate used Function. > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *hanumant shinde > *Sent:* Tuesday, May 31, 2011 1:30 AM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Generate random numbers based on number > given in a cell > > > > thanks for ur reply. but wat does F9 key do. > if i press it manually on any workbook without having macro. > wat is my understanding of your code is you are jus pressing F9 key using > sendkey function. So you are pressing F9 key using macro but if i press it > manually without macro then it shud do what your macro is doing. please > correct me if i m wrong. > > > > *From:* ChilExcel <chilexcel...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Mon, 30 May, 2011 8:42:40 PM > *Subject:* Re: $$Excel-Macros$$ Generate random numbers based on number > given in a cell > > > F9 key works for all open workbooks, without exception ... > The macro must be enclosed in the book to which you want to work ........ > only work if it is enabled > > Chilexcel > > 2011/5/29 hanumant shinde <arsfan2...@yahoo.co.in> > > can u pls give some light on this coding. i tried to debug but it jus have > sendkey F9. > so if i manually press F9 key in other workbook nothing happens there. can > u explain the logic of this macro. > > > > *From:* ChilExcel <chilexcel...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Sun, 29 May, 2011 8:42:50 PM > *Subject:* Re: $$Excel-Macros$$ Generate random numbers based on number > given in a cell > > > > Please see attached file > > > > Chilexcel > > > > > > > > 2011/5/28 Suryaprasad <suryaprasad...@gmail.com> > > Hi Experts, > > > > Need a formula or a code for the sample sheet Attached, this is about the > generating a random based numbers given in spread sheet > > > > Thanks > > Prasad > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > > Visita ; http://sites.google.com/site/chilexcel/Home > > Visita ; http://www.youtube.com/user/timextag41 > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > > Visita ; http://sites.google.com/site/chilexcel/Home > > Visita ; http://www.youtube.com/user/timextag41 > > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
