Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

2012-10-22 Thread joseph . camill
Hi, Acer is good only for basic home use, but if you need graphics as well then Acer is the wrong choice. Sent on my BlackBerry® from Vodafone -Original Message- From: Manoj Kumar Sender: excel-macros@googlegroups.com Date: Tue, 23 Oct 2012 10:54:14 To: Reply-To: excel-macros@google

Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

2012-10-22 Thread Vabz
Hi Thanks Manoj Rgds//vabs On Tuesday, October 23, 2012 10:54:33 AM UTC+5:30, Manoj Kumar wrote: > > Hi, > > U Can buy Acer Aspire S3-I5.. > > Regard > Manoj > > On Mon, Oct 22, 2012 at 4:49 PM, > wrote: > >> ** >> Wooww! Gud input.. >> >> >> Cheers//Vabs >> Sent on my BlackBerry® from Vodafone

Re: $$Excel-Macros$$ Re: Text need in different collume

2012-10-22 Thread अनिल नारायण गवली
Dear Manoj, Pl find enclosed the attachment. Regards, On Tue, Oct 23, 2012 at 11:18 AM, Manoj Kumar wrote: > Dear Expert, > >> >> I have data witch has Text and Number i want to do saperate text and >> number in next collume. >> >> man25oj kuma112r ro444ha25n 25s26on7 >> >> >> >> Regard >

Re: $$Excel-Macros$$ MsgBox Query

2012-10-22 Thread David Grugeon
Or MsgBox Sheets(1).cells(1,1) Regards David Grugeon On 23 October 2012 16:02, Eugene Bernard wrote: > > Try this > > MsgBox (Sheets(1).Range("a1")) > > Regards > Eugene > > On Tue, Oct 23, 2012 at 10:40 AM, SAJID MEMON > wrote: >> >> >> >> >> Dears, >> Find enclosed above attachemnt >> I WAN

Re: $$Excel-Macros$$ MsgBox Query

2012-10-22 Thread Eugene Bernard
Try this MsgBox (Sheets(1).Range("a1")) Regards Eugene On Tue, Oct 23, 2012 at 10:40 AM, SAJID MEMON wrote: > > > > Dears, > Find enclosed above attachemnt > I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX > > Awiting... > > Sajid Memon > > -- > Join official facebook p

$$Excel-Macros$$ Re: Text need in different collume

2012-10-22 Thread Manoj Kumar
Dear Expert, > > I have data witch has Text and Number i want to do saperate text and > number in next collume. > > man25oj kuma112r ro444ha25n 25s26on7 > > > > Regard > Manoj > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members

Re: $$Excel-Macros$$ MsgBox Query

2012-10-22 Thread Abhishek Jain
Use this - MsgBox Sheets("Sheet1").Range("A1") HTH On Tue, Oct 23, 2012 at 10:40 AM, SAJID MEMON wrote: > > > > Dears, > Find enclosed above attachemnt > I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX > > Awiting... > > Sajid Memon > > -- > Join official facebook page

Re: $$Excel-Macros$$ Re: Good Laptop to Buy..

2012-10-22 Thread Manoj Kumar
Hi, U Can buy Acer Aspire S3-I5.. Regard Manoj On Mon, Oct 22, 2012 at 4:49 PM, wrote: > ** > Wooww! Gud input.. > > > Cheers//Vabs > Sent on my BlackBerry® from Vodafone > -- > *From: * CoRe > *Date: *Mon, 22 Oct 2012 04:17:49 -0700 (PDT) > *To: * > *Cc: * > *Subj

$$Excel-Macros$$ MsgBox Query

2012-10-22 Thread SAJID MEMON
Dears, Find enclosed above attachemnt I WANT THE VALUE OR ANY TEXT IN A1 CELL SHOULD APPEAR IN THE MESSAGE BOX Awiting... Sajid Memon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ m

Re: $$Excel-Macros$$ ONLINE .NET TRAINING

2012-10-22 Thread noorain . ansari
Dear Ayush, Pls ban this email id Sent from BlackBerry® on Airtel -Original Message- From: mytrani...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 17:33:36 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ ONLINE .NET TRAINING HI, PLEAS

$$Excel-Macros$$ ONLINE .NET TRAINING

2012-10-22 Thread mytranings
HI, PLEASE FIND THE BELOW LINK FOR .NET ONLINE TRAINING AND PROJECT SUPPORT. http://onlinenettrainings.blogspot.com/ PLEASE FEEL FREE TO CONTACT FOR ANY QUERIES TO BELOW MAIL ID rudrajayku...@gmail.com THANK YOU AJAY KUMAR -- Join official facebook page of this forum @ https://www.facebook.com

Re: $$Excel-Macros$$ Adding OR in between numbers using macro

2012-10-22 Thread ashish koul
USE THIS UDF Function concatenate_nonblanks(x As Range, spl As String) Dim cell As Range Dim rsl As String For Each cell In x If cell <> vbNullString Then rsl = rsl & spl & cell End If Next concatenate_nonblanks = Right(rsl, Len(rsl) - Len(spl)) End Function in cell b8 type = =concatenate_nonbla

Re: $$Excel-Macros$$ countif in hidden rows

2012-10-22 Thread Vabz
Hi PFA Rgds//Vabs On Monday, October 22, 2012 8:14:41 PM UTC+5:30, danial mansoor wrote: > > u did not get it,sir in subtotal we don't have option of Counting things > with conditions as we do with countif,so i want a way to count with > condition with hidden rows. > > to make it more elabora

RE: $$Excel-Macros$$ countif in hidden rows

2012-10-22 Thread danial mansoor
u did not get it,sir in subtotal we don't have option of Counting things with conditions as we do with countif,so i want a way to count with condition with hidden rows. to make it more elaborate when i use countif with hidden rows it counts everything including hidden and unhidden rows but i w

$$Excel-Macros$$ Adding OR in between numbers using macro

2012-10-22 Thread Vignesh S R
hi, I have to add one variable "OR" in between numbers I have attached the excel sheet. Kindly do the needful. Input : 1231 , 1234 , 12345 , 4342 Output 1231 OR 1234 OR 12345 OR 4342 -- Vignesh .S.R -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RU

Re: $$Excel-Macros$$ countif in hidden rows

2012-10-22 Thread vba
Hi, For countif you have to use 102 with subtotal formula. Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: danial mansoor Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 13:50:58 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros

$$Excel-Macros$$ countif in hidden rows

2012-10-22 Thread danial mansoor
Dear Experts, kindly provide me countif formula for hidden rows, i triend to use subtotal but could fine the way,kindly provide me formula. From: aamirshahza...@gmail.com Date: Mon, 22 Oct 2012 17:11:03 +0500 Subject: Re: $$Excel-Macros$$ Formula Needed ! To: excel-macros@googlegroups.c

Re: $$Excel-Macros$$ Formula Needed !!!!!

2012-10-22 Thread Aamir Shahzad
use below formula for get desired sum =SUMIF($B$2:$B$663,E3,$C$2:$C$663) On Mon, Oct 22, 2012 at 5:06 PM, Amresh Maurya wrote: > PFA File > > On Mon, Oct 22, 2012 at 5:27 PM, Shaikh Iqbal > wrote: > > Thx Abhi > > > > > > > > > > Regards, > > > > Iqbal S > > > > > > On 22 October 2012 17:24, a

Re: $$Excel-Macros$$ Formula Needed !!!!!

2012-10-22 Thread Shaikh Iqbal
Thx Abhi Regards, Iqbal S On 22 October 2012 17:24, abhishek agarwal wrote: > > > Dear Shaikh Iqbal > > > > > Please find the attachment for the same > > > > > On Mon, Oct 22, 2012 at 5:18 PM, Shaikh Iqbal wrote: > >> Dear Exports, >> >> Need help in attached file. >> >> >> >> >> >> >> >> >>

Re: $$Excel-Macros$$

2012-10-22 Thread vba
Hi Right click on your module, under protection you can opt for setting password. Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Shrinivas Shevde Sender: excel-macros@googlegroups.com Date: Mon, 22 Oct 2012 16:46:55 To: Reply-To: excel-macros@googlegroups.co

$$Excel-Macros$$ Re: Good Laptop to Buy..

2012-10-22 Thread vba
Wooww! Gud input.. Cheers//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: CoRe Date: Mon, 22 Oct 2012 04:17:49 To: Cc: Subject: Re: Good Laptop to Buy.. Hello, The configuration is oke , video card should be separated not integrated and as for company that you

$$Excel-Macros$$ Re: Good Laptop to Buy..

2012-10-22 Thread CoRe
Hello, The configuration is oke , video card should be separated not integrated and as for company that you should choose , i rather opt for Asus ,Toshiba. On Saturday, October 20, 2012 3:03:22 PM UTC+3, Vabz wrote: > > Hi, > > All I want to buy good laptop for my personal use, pl experts s

Re: $$Excel-Macros$$

2012-10-22 Thread Shrinivas Shevde
Dear Tem members, can anyone explain me how to protect the code Regards Shrinivas On Mon, Oct 22, 2012 at 4:44 PM, Shrinivas Shevde wrote: > Dear Rajan > Thanks > Regards > Shrinivas > > On Sat, Oct 20, 2012 at 2:53 PM, Rajan_Verma wrote: > >> * * >> >> *Here are a simplest example,* >> >> *

Re: $$Excel-Macros$$

2012-10-22 Thread Shrinivas Shevde
Dear Rajan Thanks Regards Shrinivas On Sat, Oct 20, 2012 at 2:53 PM, Rajan_Verma wrote: > * * > > *Here are a simplest example,* > > * * > > *You can use this code to understand the thing about screen updating > True/False* > > * * > > *ScreenUpdating is Application Property , so it works on app

Re: $$Excel-Macros$$ Trouble in 2007

2012-10-22 Thread KAUSHIK SAVLA
On Oct 21, 2012 5:31 PM, "SAJID MEMON" wrote: > Dear experts, > > I have done a small project in excel 2003 with some command buttons. when > i open my project in excel 2007 then command buttons are not press or > working. > Why this problem come in 2007? please give me settings or any suggessti

Re: $$Excel-Macros$$ Trouble in 2007

2012-10-22 Thread Divaker Pandey
What about macro setting on your Excel 2007 application Divaker On Sun, Oct 21, 2012 at 5:30 PM, SAJID MEMON wrote: > Dear experts, > > I have done a small project in excel 2003 with some command buttons. when > i open my project in excel 2007 then command buttons are not press or

Re: $$Excel-Macros$$ Query related to Salary binding up

2012-10-22 Thread Ankit Agrawal
Hi all, Need help on this. Regards, Ankit On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal wrote: > Hi Haseeb, > > Thanks for your mail. this is really help me. but I have some point which > can make it more effective and efficient. > > >- Department code will be written automatically. >-

$$Excel-Macros$$ Re: Abc in a column

2012-10-22 Thread Prince
Hi Manoj =MID(ADDRESS(1,COLUMN()),2,1) Prince On Saturday, October 20, 2012 10:05:27 PM UTC+5:30, Manoj Kumar wrote: > > Hi expert > > I want ABC in a column. So can u help me on this. In a column ABC from a > to z. > > Thanks > Manoj > -- Join official facebook page of this forum @ https