$$Excel-Macros$$ Re: Filter Problem in Excel 2003

Mr Ramesh, I think the filter drop down list has a limitiation of 1000 entries in excel 2003 which might be extended to a bigger number in excel 2007. Again the dropdowns are re-populated when filter is set on a column. For example, I filtered on 'Customer No' column for Nov-10, it got out

Re: $$Excel-Macros$$ Delete rows including blank row except few members

Hi Hari, Just Insert the Code in VBA Module, Like, press Alt+F11, VBA window will open, then, just from the menu bar, Insert , Module, there you will place the code. Here is a link: www.contextures.com/xlvba01.html http://www.contextures.com/xlvba01.htmlKeep Smiling, On Mon, Nov 8, 2010 at

$$Excel-Macros$$ Re: How to change multiple values

You can change Manually... Do F2 then = existing value * 40% Else through macro it can easily possible On Nov 8, 10:36 am, Vaaibhav vaaibhavjhav...@gmail.com wrote: Hello All Is there any shortcut for changing values in various cells (same column) to a same multiplier. I am just elaborationg

$$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Dear Group Members, Good news for all of you !! Now you can download VBA macros ebook worth $45 for free. Here is the link to download :- http://recordexcelmacro.com/discussexcel.html I have talked to John Franco (Author) to get this eBook for our group. Please do not miss the chance to

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Thank you so much Ayush:) On Mon, Nov 8, 2010 at 6:05 AM, Ayush jainayus...@gmail.com wrote: Dear Group Members, Good news for all of you !! Now you can download VBA macros ebook worth $45 for free. Here is the link to download :- http://recordexcelmacro.com/discussexcel.html I

$$Excel-Macros$$ array sort issue

In an attempt to develop my own sort for an array, I seem to have run into a problem. I don't know what I 'm doing wrong specifically, but as soon as I attempt to invoke the Len Function, the whole thing breaks. subscript out of range error. I think I may be overthinking this, so any guidance

Re: $$Excel-Macros$$ Excel VBA Macros eBook ..Absolutely FREE worth $45

Thanks, Will always come in handy. Rgds, Chris On Tue, Nov 9, 2010 at 6:49 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Thank u very much Ayush dear... Regards, Noorain On Mon, Nov 8, 2010 at 5:50 PM, Venkat venkat1@gmail.com wrote: Dear Ayush, Thanks a Lot:)

$$Excel-Macros$$ Re: How to change multiple values

Hello saggi I think you must have given this reply considering that I have only 4 rows to be changed. What if I have 4000 rows to be changed at same point of time? Kindly help if you can. Regards Vaaibhav On Nov 8, 4:51 pm, saggi realsa...@gmail.com wrote:  You can change Manually... Do F2