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

2010-11-08 Thread Vaaibhav
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 wrote: >  You can change Manually... Do F2 then = existing valu

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

2010-11-08 Thread sumit kumar
Thanks a lot dear Regards Sumit On Tue, Nov 9, 2010 at 10:19 AM, NOORAIN ANSARI wrote: > > > Thank u very much Ayush dear... > > Regards, > Noorain > > On Mon, Nov 8, 2010 at 5:50 PM, Venkat wrote: > >> Dear Ayush, >> >> Thanks a Lot:) >> >> *Best Regards,* >> *Venkat* >> >> >> >> >> On M

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

2010-11-08 Thread Christo van Schalkwyk
Thanks, Will always come in handy. Rgds, Chris On Tue, Nov 9, 2010 at 6:49 AM, NOORAIN ANSARI wrote: > > > Thank u very much Ayush dear... > > Regards, > Noorain > > On Mon, Nov 8, 2010 at 5:50 PM, Venkat wrote: > >> Dear Ayush, >> >> Thanks a Lot:) >> >> *Best Regards,* >> *Venkat* >>

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

2010-11-08 Thread NOORAIN ANSARI
Thank u very much Ayush dear... Regards, Noorain On Mon, Nov 8, 2010 at 5:50 PM, Venkat wrote: > Dear Ayush, > > Thanks a Lot:) > > *Best Regards,* > *Venkat* > > > > > On Mon, Nov 8, 2010 at 7:35 PM, Ayush wrote: > >> Dear Group Members, >> >> Good news for all of you !! >> >> Now you can

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

2010-11-08 Thread Venkat
Dear Ayush, Thanks a Lot:) *Best Regards,* *Venkat* On Mon, Nov 8, 2010 at 7:35 PM, Ayush 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/discusse

$$Excel-Macros$$ array sort issue

2010-11-08 Thread Ted
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 is

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

2010-11-08 Thread Vijay Kr. Aggarwal
Thank you so much Ayush:) On Mon, Nov 8, 2010 at 6:05 AM, Ayush 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 have talked to

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

2010-11-08 Thread Ayush
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 downloa

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

2010-11-08 Thread saggi
You can change Manually... Do F2 then = existing value * 40% Else through macro it can easily possible On Nov 8, 10:36 am, Vaaibhav wrote: > Hello All > > Is there any shortcut for changing values in various cells (same > column) to a same multiplier. I am just elaborationg - say in Column A > i

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

2010-11-08 Thread krishna mummina
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 Keep Smiling, On Mon, Nov 8, 2010 at 9

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

2010-11-08 Thread Kishan Reddy, K
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 'depo