Re: $$Excel-Macros$$ Generate random numbers based on number given in a cell
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 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 > *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 > > 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 > *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 > > 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/discuss
RE: $$Excel-Macros$$ Generate random numbers based on number given in a cell
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 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 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 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 http://suryaprasad.bv/> @gmail.com <http://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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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/exc
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 >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 > >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 >>>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 >>> >>>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 >> > > >-- > &g
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 > 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 > *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 > >> 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
Re: $$Excel-Macros$$ Generate random numbers based on number given in a cell
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 >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 > >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