Re: $$Excel-Macros$$ Re: Urgent:: Is there a way out to increase the cell character limit to beyond 255.

2011-05-31 Thread Bharghav Ramdas
Thanks. On Mon, May 30, 2011 at 11:14 PM, Sixthsense sixthsense...@gmail.comwrote: Hi Bharghav, You can extract the data by using formula which will do the same work which you are trying to derive by using the Text To Columns. Change the cell reference A2 to your desired cell. This is a

Re: $$Excel-Macros$$ Generate random numbers based on number given in a cell

2011-05-31 Thread Sixthsense
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.comwrote: F9 Only Calculate used Function. *From:* excel-macros@googlegroups.com [mailto:

$$Excel-Macros$$ sum of least 8 subjects

2011-05-31 Thread ayoub Kakande
Urgent help needed I have 18 subjects, 6 of them are compulsory from the other 12 a student offers only 2 to make a total of either 9 or ten subjects/papers. I need a formula to computer the sum of the least eight subjects done for each student. N.b if a student attempts less than 8 subjects it

$$Excel-Macros$$ Re: sum of least 8 subjects

2011-05-31 Thread DILIPandey
Hi Ayoub, It would be very helpful for the Group if you can share a sample scenario of your problem. Thanks, DILIPandey On May 31, 2:45 pm, ayoub Kakande akaka...@gmail.com wrote: Urgent help needed I have 18 subjects, 6 of them are compulsory from the other 12 a student offers only 2 to

Re: $$Excel-Macros$$ If #N/A then enter your own value?

2011-05-31 Thread AJAY KURUP
Hey whether this will work with all office versions or with version later than office 2007 On Tue, May 31, 2011 at 11:15 AM, Dilip Pandey dilipan...@gmail.com wrote: Hi Bob, After your formula part of the code, insert the following:- If IsError(Range(b3)) = True Then Range(b3).Value =

RE: $$Excel-Macros$$ Conversion of PDF Data To Excel Sheet

2011-05-31 Thread Susan
I use http://pdftransformer.abbyy.com/ From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vikas gupta Sent: Tuesday, April 26, 2011 2:46 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Conversion of PDF Data To Excel Sheet HI BADAL

$$Excel-Macros$$ EXCEL VBA

2011-05-31 Thread P.VIJAYKUMAR
Dear All, I am Completely new to VBA.I don't know its terminology and how to write programs to execute specific action in Excel.I want to learn Excel VBA in an easy way.Any E book would be of immense help to me and other people would like to learn VBA.Please upload any VBA material .

Re: $$Excel-Macros$$ If #N/A then enter your own value?

2011-05-31 Thread Dilip Pandey
Hi Ajay, This should work in all versions except where vb.net present needs to be customized, though I am not 100% sure. Best Regards, DILIPandey On 5/31/11, AJAY KURUP kurupajayku...@gmail.com wrote: Hey whether this will work with all office versions or with version later than office 2007

Re: $$Excel-Macros$$ EXCEL VBA

2011-05-31 Thread Dilip Pandey
Hi Vijay, I would suggest to check the Group's page for ebooks. Alternatively, you can also google and download pdf books as per your choice. There are many online tutorials available as per various expertise levels and may be you can search Excel VBA tutorials for beginners. Best Regards,

Re: $$Excel-Macros$$ Conversion of PDF Data To Excel Sheet

2011-05-31 Thread Vishal Gupta
u can use OCR (optical character reader) On Tue, May 31, 2011 at 8:11 PM, Susan sunni...@gmail.com wrote: I use http://pdftransformer.abbyy.com/ *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *vikas gupta *Sent:* Tuesday, April 26, 2011 2:46

Re: $$Excel-Macros$$ Requesting for a small help in vba coding....

2011-05-31 Thread Indrajit $nai
Thanks Ranjan, thanks a lot. On Tue, May 31, 2011 at 10:11 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi, Paste this Code For Save Button. Private Sub CommandButton1_Click() On Error Resume Next Dim wb As Workbook Dim acwb As Workbook Set acwb = ActiveWorkbook

Re: $$Excel-Macros$$ If #N/A then enter your own value?

2011-05-31 Thread Bob
This does work. But only for range B3. Is there a way to once B3 has already been entered go to NEXT ROW. Thanks so much for your help!!! On May 31, 1:45 am, Dilip Pandey dilipan...@gmail.com wrote: Hi Bob, After your formula part of the code, insert the following:- If IsError(Range(b3)) =

Re: $$Excel-Macros$$ Highlight previous revision Cells after new entry of New Revision

2011-05-31 Thread Rohan Young
Dear Experts, This is the status of Drawing, when we received the next revision of drawing (i.e. we receive R1 after Ro), i need , when i enter the next revision the last revision cells should be green highlighted, so i can understand this drawing goes superceded, here is another change also