Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-16 Thread Dilip Pandey
You are always welcome Greg... :) It would be good if you start a new thread (query posting) in future with a nice subject line so that every one can help you and learn with your challenge(s). :) Best Regards, DILIPandey On Thu, Sep 16, 2010 at 3:04 PM, gdbar...@googlemail.com < gdbar...@google

$$Excel-Macros$$ Random Numbers generation

2010-09-16 Thread Giorgio
All, I need to build an excel that generates X unique series of 5 random numbers, lottery style (no repetition in the same series and no repetition across the series). I know the function RANDBETWEEN, but how can I include the "no repetition"? Thank you, G --

Re: $$Excel-Macros$$ how to print only rows with data and not inlcude rows with a formula

2010-09-16 Thread Paul Schreiner
you need to add:     LookIn:=xlValues, _ to your .Find construct so that it looks for Values instead of values and formulas. Paul - Original Message > From: Mel > To: MS EXCEL AND VBA MACROS > Sent: Wed, September 15, 2010 12:51:13 PM > Subject: $$Excel-Macros$$ how to print only rows

Re: $$Excel-Macros$$ Extract the text from Textbox and return back after editing

2010-09-16 Thread Paul Schreiner
You didn't include your code. Did you want us to rewrite it too? the code you have for extracting the contents is very close to what is needed to replace it. Paul - Original Message > From: Chandru > To: excel-macros@googlegroups.com > Sent: Thu, September 16, 2010 7:03:28 AM > Subje

$$Excel-Macros$$ Extract the text from Textbox and return back after editing

2010-09-16 Thread Chandru
Hello experts I wish to have an excel macro that can extract text from all the text boxes from one sheet and then list out that text in another sheet. I can find some macros for this from the internet. Now my requirement is to return back that text to the same text box after editing. I am not able

Re: $$Excel-Macros$$ Finding specific text and returning nearby data (from another column)

2010-09-16 Thread gdbar...@googlemail.com
Hi Dilip Thanks so much for the workbook - it's great. I have some more work to do on the project. So I may need your help again in the future?! Do you think it is best to re-submit to this post? Or start a new thread? Thanks again. Greg On 11 Sep, 16:26, Dilip Pandey wrote: > Hi Greg, > >

$$Excel-Macros$$ Hi

2010-09-16 Thread dinoabeer
Can somebody help. I m a newbie here. how do I upload I file when I post something> -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2.