M, Deba Ranjan wrote:
>
>> i agree with Mangesh. its seems very critical abuse word.
>>
>>
>> Thanks & Regards,
>> *Deba Ranjan P*
>>
>>
>>
>>
>>
>> On Fri, Jun 8, 2012 at 4:50 PM, Mangesh Dayne wrote:
>>
>>&g
What do u say so...
It shouldn't happen
On Fri, Jun 8, 2012 at 4:49 PM, Viktorija Zukauskiene <
vzukauskien...@gmail.com> wrote:
> fuck off, and never sand that forrever ok?
>
>
> 2012/6/8 Mangesh Dayne
>
>> Hi Friends,
>>
>>
>> I have
Hi Friends,
I have to add combo box in a sheet that will contain all sheets name and
when i select the any sheet name in combo box, it will activate in the
workbook, means I can able to see the contents of sheet simply by selecting
the sheet from combo box list. Moreover, combo box should automat
Thanks All !!!
On Fri, Jun 8, 2012 at 3:27 PM, Anoop K Sharma wrote:
> Follow Noorain's method...
>
>
> On Fri, Jun 8, 2012 at 11:07 AM, NOORAIN ANSARI
> wrote:
>
>> Yes, Sure Vivek it is possible..
>> Please use
>>
>> =vlookup(Lookup value,Index File refernce,File No.,0)
>>
>> it will better i
Hi friends, pls do needful. Thanks. Mangesh. [sent frm phone]
On 6/7/12, Mangesh Dayne wrote:
> Hi Friends,
>
> Please find the attached sheet and for this, I need average for the pivot
> table.
> Also explain me procedure.
>
> Thanks
>
>
> Mangesh
>
> --
tFunction.Substitute(wksSheet.Name, "Result_", "")) + 1
>
> End If
>
> Next wksSheet
>
> End Sub
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* exc
wksSheet
>
> End Sub
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne
> *Sent:* 0
Hi Friends,
I came across good scenario while working in excel.
I have the worksheet named "*Result*" which contain important data
and whenever I open the file I need this Result sheet should become
Result_1 automatically, so that there should not be *Result* sheet
available in workbook. If I open
Hi Friends,
I am working with the file containing macros.
I want all macros should be disable when i opened the file and should be
enable when i click on command button in file.
My intention is to stop executing the macro just after opening the file. It
should be run only when i click on command b
Congrats Rajan + Noorain + Vijay = Excel Group
Keep it up
Enjoy !!!
MangesH
On Mon, Jun 4, 2012 at 11:24 AM, Nikhil Shah wrote:
> Congratulation Rajan
>
> Nikhil Shah
>
>
> On Mon, Jun 4, 2012 at 11:02 AM, Maries wrote:
>
>> *Congrats Brother.*
>>
>>
>> On Sun, Jun 3, 2012 at 9:3
Hi,
So it can be solved by using VBA if elseif statement.
MangesH
On Thu, May 31, 2012 at 3:24 PM, LAKSHMAN PRASAD wrote:
> Hello everybody,**
> But if we want like under example …..
>Amount
> Round figer
> 1864138
> 190
> 361408
> 40
> 46565
Hi Noorain bhai,
Instead of sending the file to individual's mail id, u can send it to group
so that any member could share it.
Mangesh
On Wed, May 30, 2012 at 2:45 PM, abhishek agarwal <
abhishekagarwal...@gmail.com> wrote:
> Dear Noorain Sir ,
>
> Please send me also.
> abhishekagarwal...
CurrentRegion.AutoFilter
>
> Else
>
> MsgBox "Please Enter a Domain Name", vbInformation, "Enter Domain"
>
>
> End If
>
> End Sub
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [I
gt;
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne
> *Sent:* 29 May 2012 7:32
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need help for Domain Codes
>
> ** **
>
> Hi Fr
Hi Friends,
I need your help for Domain Codes search for file.
Please find the attached sheet.
With regards,
MAnGesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, C
Noorain bhai,
Dhanyawad Kya kahu... Agar dhanyawad ki hi bat hai to hamesha yahi dil se
kahta rahunga...
"U R SIMPLY OXYGEN OF THIS GROUP DEAR"
with regards,
MangEsh.
On Tue, May 29, 2012 at 6:35 PM, Rajan_Verma wrote:
> *I just study Excel 2003 Power programming with VBA by J-Walk when I
> s
Hi Noorain,
Send same for Excel 07 Please.
Thanks
MAnGesh
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI wrote:
> Dear Sagar,
>
> Please find attached study material of Basic Macro and follow excel-macro
> group on regular basis.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainans
Check mails of this group.
It has been already answered some days before.
ManGesh
On Tue, May 29, 2012 at 1:36 PM, Smitha S R wrote:
> Hi,
>
> I have a drop down list which is created using menu 'data validation'.
>
> Is it possible to get the items in the first line in the drop down while
>
Hi Smitha,
Use data validation from Excel.
MAngesH
On Tue, May 29, 2012 at 2:01 PM, Smitha S R wrote:
> How we can place a combo box in excel work sheet?
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Pleas
oday it clicked me...
>
> ** **
>
> Best Regards,
>
> Amit
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne
> *Sent:* 28 May 2012 17:29
> *To:* excel-macros@googlegroup
Hi All,
Please help me on below query.
With regards,
Mangesh
On Mon, May 28, 2012 at 5:12 PM, Mangesh Dayne wrote:
> HI Noorain,
>
> Thanks for your reply.
> However, I didn't get about the red highlighted code.
> I have attached snapshot about what I need. Please find it
HI Amit,
Thats good but can you share your answer within group so that excel lovers
like me could understand it for future ref. U can attached solved sheet too.
Thanks
With regards,
Mangesh
On Mon, May 28, 2012 at 10:41 AM, Amit Desai (MERU) wrote:
> I got the solution by some R&D.. thanks
>>>
>>>
>>>
>>> On Fri, May 25, 2012 at 7:16 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
>>>> Dear Mangesh,
>>>>
>>>> To Create filter you can also use Short-Cut keys
>>>&g
Hi,
I have use filter by keyboard shortcuts.
Find the attached sheet.
I know the shortcut keys for doing so like Alt+ A, T but how to select
filter option in sheet (handle and elements in it).
Thanks
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread ti
Hi All,
Please help me on attached sheet.
Thanks lot.
with regards,
Mangesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Hi All,
Welcome decision.
In addition, it is also good that job posting should be related to excel,
vba only.
Our objective is to make universal platform for EXCEL/VBA LOVERS.
with regards,
Mangesh
On Mon, May 21, 2012 at 7:10 PM, wrote:
> **
> Hi Ayush sir,
>
> Can you plz exlude me from thi
Thanks
It works.
On Wed, May 16, 2012 at 9:41 PM, Maries wrote:
> Hi,
>
> Try it,
> *
> =COLUMN()*25+ROW()*
>
>
>
> On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote:
>
>> I am happy for your kind support
>>
>> Pls help me again for below i
I am happy for your kind support
Pls help me again for below issue .
Find attached sheet
Thanks.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Nee
ooglegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of ?» lal?? ?sa??
> Sent: 16 May 2012 7:14
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Time Difference
>
> Dear Mangesh
>
> PFA
>
> Regards,
> Lalit Mohan
> https://www.facebook.c
Hi,
Thanks for your great help.
In vba code,
Range("C11").Value = Range("C10") + 0.2916667
why did you have taken 0.2916667 value and many other in formula.
Please explain the logic behind it.
Thanks
Mangesh
On Wed, May 16, 2012 at 6:43 PM, Maries wrote:
> Hi,
>
> Find the
Hi Friends,
Please help me on this issue.
Please refer the attached file.
In file, I need time at other countries depending on the time in Mumbai.
Time difference is mentioned in the sheet.
Please help me by providing answer/vba code.
Thanks
Mangesh
--
FORUM RULES (986+ members already BAN
Its really valuable material and study file I have ever seen in my
life...!!!
User friendly
Thanks friend !!!
U r simply gr8.
On Tue, May 15, 2012 at 6:34 PM, danial mansoor wrote:
>
> dear Noorani,
>
> do you have material for intermediate level user in which macro and other
> material related
Ok.
Thanks rajan.
On Tue, Apr 10, 2012 at 10:17 PM, Rajan_Verma wrote:
> I think Text is a read only property here
>
> ** **
>
> Rajan.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayn
of Text
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne
> *Sent:* Apr/Tue/2012 10:12
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need help !!!
>
> ** **
>
Hi all,
I have created small code but it is showing error message as "Object
required".
*The code is -*
Sub gen()
If Sheet1.Range("A2").Value > 50 Then
Sheet1.Range("B2").Text = "You have entered the value above 50"
Else
Sheet1.Range("B2").Text = "You have entered the value below 50"
End If
End Su
l-2007_766373.html
>
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne
> *Sent:* Apr/Fri/2012 10:16
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need chart rel
mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mangesh Dayne
> *Sent:* Apr/Fri/2012 08:30
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need chart related vba codes
>
> ** **
>
> Hi All,
>
> ** **
>
> Can you se
Hi All,
Can you send me chart related vba codes like creating, editing chart based
on the data in Excel.
Kind regards,
Mangesh
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi Rajan,
I need some web links for the study material of excel vba. So kindly send
me links so that I could learn vba.
With regards,
Mangesh Dayne
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
---
Mangesh Dayne wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-39630eaae8-0f6e46ff2e-POa8AcgjdL8eh-GF-4az46SJV4s
Y
Hi Rajan,
Kindly tell me where i can put above written code in vba editor.
I am trying to learn these concepts so please help me.
Thanks !!!
On Wed, Apr 4, 2012 at 6:13 PM, Sharath Sambrani <
sharath.c.sambr...@gmail.com> wrote:
> Thanks Rajan,
>
> It worked!
>
> Appreciate your quick reply.
>
Hi Darwin,
If you are not able to see mentioned reference " Microsoft Outlook 12.0
Object Library " in your machine, then probably you can get it by
installing VB 6.0 edition in your computer.
Mangesh.
On Wed, Mar 28, 2012 at 3:49 PM, Jorge Marques wrote:
> Talal, i´m also a beginner, i´m u
Hi.
Thanks for your kind support.
Would you please provide me User name and password so that I could login.
Thanks.
Mangesh
On Thu, Feb 16, 2012 at 6:08 PM, Veeru TOC wrote:
>
>
> Dear All,
>
>
>We all using of web site
> https://i-navigator.industowers.com, In this w
43 matches
Mail list logo
