RE: $$Excel-Macros$$ Cannot remove rows

2011-02-26 Thread Daniel
What happens ? do you get an error message ? Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de SteveO Envoyé : samedi 26 février 2011 04:06 À : MS EXCEL AND VBA MACROS Objet : $$Excel-Macros$$ Cannot remove rows MS Excel

$$Excel-Macros$$ Entry of more than 16 characters in a cell

2011-02-26 Thread Ashish Khandelwal
Hi friends, When I enter a 16 digit number in a cell, the last digit become 0. How can I enter a 16 or more digit number in a cell. Thanks Regards, Ashish. -- -- Some important links for excel users: 1. Follow

Re: $$Excel-Macros$$ Cannot remove rows

2011-02-26 Thread rana sohail
what kind of error , excel is giving On Sat, Feb 26, 2011 at 8:06 AM, SteveO watog...@gmail.com wrote: MS Excel 2007, Office 7: I consider myself to be power user. I have a spreadsheet with roughly, 12,000 rows. I went to delete 120 rows at about row 10,000 and they will not go away,

Re: $$Excel-Macros$$ SubTotal and Insert Req

2011-02-26 Thread rana sohail
if u want to insert row after the subtotal line (i.e u are saying that you want to insert a blank row between the subtal line, and the next group.) 1-Right Click below the subtotal row, or on first row of below group 2-Click on insert 3-Select entire row 4-Click ok If u have any further

Re: $$Excel-Macros$$ Cannot remove rows

2011-02-26 Thread SteveO
Nothing happens. Excel briefly behaves as if it is doing something, but the rows remain. I tried an experiment where I put values in ColumnA, and those values were erased, but the blank rows remain. On Feb 26, 4:33 am, Daniel dcolarde...@free.fr wrote: What happens ? do you get an error

Re: $$Excel-Macros$$ Entry of more than 16 characters in a cell

2011-02-26 Thread Vikas Chouhan
Hi, use single quote ' then type 16digit number '12345678912345678 On Sat, Feb 26, 2011 at 1:31 PM, Ashish Khandelwal 4everash...@gmail.comwrote: Hi friends, When I enter a 16 digit number in a cell, the last digit become 0. How can I enter a 16 or more digit number in a cell. Thanks

RE: $$Excel-Macros$$ Entry of more than 16 characters in a cell

2011-02-26 Thread Anil Bhange
XL has a specification limit of 15 decimal digits of precision (see Help, Specifications). There's nothing you can to in XL itself to extend the precision. There are a few add-ins around that you can Google that claim to give up to 200 decimal digits of precision, but I haven't tried any of them.

Re: $$Excel-Macros$$ SubTotal and Insert Req

2011-02-26 Thread Pehrson, Dave
Thank you Rana, for your kind support. Is it possible to accomplish this with a macro as I hane many rows to deal with? Thanks Dave From: excel-macros@googlegroups.com To: excel-macros@googlegroups.com Sent: Sat Feb 26 01:45:23 2011 Subject: Re:

RE: $$Excel-Macros$$ Cannot remove rows

2011-02-26 Thread Daniel
Can you copy the data into a blank workbook and try with this new one ? Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de SteveO Envoyé : samedi 26 février 2011 13:01 À : MS EXCEL AND VBA MACROS Objet : Re: $$Excel-Macros$$

$$Excel-Macros$$ Multi User in Excel file

2011-02-26 Thread SAJID MEMON
Dear All Experts, I have LAN in my office and want to type in a excel file (Example : abc.xls) data. Can other person type in same file entering data like Multi User. Plz give me tips awaiting your positive responce. Regards Sajid Memon --

RE: $$Excel-Macros$$ SubTotal and Insert Req

2011-02-26 Thread Anil Bhange
Another way, Do filter on database select all visible cells (Alt + ;) then insert row, it will insert row before all Sub Total's lines Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of

$$Excel-Macros$$ Problem on picking series in chart

2011-02-26 Thread Gaurav Ahuja
Hi All, I am trying to construct chart with series selected from a table with only selected series to be represented in chart. I tried using check-box for every series but the legend still reflects all the series (including not selected series). i Hope there is a better way to handle this. I

$$Excel-Macros$$ Group Survey : Your feedback is important.

2011-02-26 Thread Ayush
Dear members, Thanks for all your contribution to group. I am very happy to see the great engagement in the group. For me its very important to know what you feel about the group, So that I can take any action or initiative on the basis of your feedback. This is an anonymous survey , so feel

Re: $$Excel-Macros$$ Conditional Format Duplicate Rows

2011-02-26 Thread John A. Smith
This is excellent. Thank you for your help. John On Thu, Feb 24, 2011 at 11:07 PM, Rohan Young rohan.j...@gmail.com wrote: Hi, see the attachment if it help thanks regds, ROHAN On Thu, Feb 24, 2011 at 8:05 PM, John A. Smith johnasmit...@gmail.comwrote: Your kind help please. I

$$Excel-Macros$$ inserting a sample file

2011-02-26 Thread Diamond Dave
How do you insert a sample fine to the inital discussion message? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

Re: $$Excel-Macros$$ Insert row based on criteria

2011-02-26 Thread Diamond Dave
I'm also trying it insert a row, but in my example, I want to insert in after the SubTotal after using the subtotal function adding the blank row after the subtotal line. How would you modify the macro in your example to accomplish this? Dave On Feb 26, 12:44 am, Mahesh parab mahes...@gmail.com

Re: $$Excel-Macros$$ inserting a sample file

2011-02-26 Thread ashish koul
write a mail to excel-macros@googlegroups.com and attach your sample file On Sun, Feb 27, 2011 at 2:27 AM, Diamond Dave dpehr...@walbro.com wrote: How do you insert a sample fine to the inital discussion message? --