Hey Mahender,
N() formula is used to hide the text. Its similar to comments in any
other programming languages.
Ex: Lets say i want to find out the area of a rectangle. Then the formula is
a*b.
In cell A1, i write =5*6+N("side1*side2"), the answer you get is 30. But you
cannot see N("side1*si
Hi all,
Can anyone send me a ppt or an overview abt macros
i want to learn the basics of macros. is there any one who can help me with
this
Thanks in advance
Regards,
Lingesh
--~--~-~--~~~---~--~~
---
Hey Mahender,
*N() *formula is used to hide the text. Its similar to *comments *in any
other programming languages.
Ex: Lets say i want to find out the area of a rectangle. Then the formula is
a*b.
In cell A1, i write =5*6+N("side1*side2"), the answer you get is 30. But you
cannot see N("side
Hi Ruchi,
Not sure I understand all your needs.
Take a look at the attached and tell me if I'm on the right track
Regards - Dave.
> Date: Wed, 17 Jun 2009 22:38:51 +0530
> Subject: $$Excel-Macros$$ Re: Vlookup
> From: ruchigab...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi
>
> actu
Hi Harmeet,
Can provide some samples, it will be a gr8 help for us?
Rgds,
Mahender Bisht
On Tue, Jun 9, 2009 at 12:29 AM, Harmeet Singh wrote:
> HI All,
>
> Name : Harmeet
> Subject : Hidden text in Formula
> Tip : *=2018+1056-4*120+N("My Salary + Bonus - 4 weekly loan
> repayments")
> *
>
Hi
actually i send 1 query in the group but i hvnt get ne reply yet plz
help me otherwise i will b in trouble
my probs is i hv file in which i hv mention th eintervals acc. to that
i want to get the frequency and avg and also i hv to make chart which
showz the counts frquency as well as avg but a
Hi
I would undoubtedly say " East or West-- Harmeet Singh is one of the kings
of this group."
regards
Hari kumar
On Wed, Jun 17, 2009 at 1:10 PM, Harmeet Singh wrote:
> Hi Ayush,
>
> Thanks a lot
> This is the charm of Excel Group that is attracting good talent.
> Hope to help you all in futu
Hello Sathyan
Please post your queries to the same email id. Anyone of the
receipients who can provide the solution will gladly do so.
Happy excelling
Ashish
On 6/17/09, sathyan narayanan wrote:
> I am slowly learning Excel
> Please let me know how I can post my questions regarding Excel Mac
Akhilesh,
Thanx for replying to my query...
--
Thanks and Regards
Bharghav R
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and T
Hi
oh this is gr8
thank u
regards
ruchi
On Wed, Jun 17, 2009 at 5:17 PM, Dilip Pandey wrote:
> Hi Ruchi,
>
> This query is related to the "linking of the files onto a excel
> spreadsheet".
> For example, you have some week - wise spreadsheets in your c drive (e.g.
> C:\Ruchi\work). The files m
Hey Dave,
You know wat.
u made my day with ur comments
Thnx!!!
On Thu, Jun 18, 2009 at 4:21 AM, Dave Bonallack
wrote:
> Good choice Ayush. I also thought it was very good.
> It's the Worksheet-Function equivalent of putting comments after an
> apostrophe in VBA.
> Regards - Dave.
>
>
Good choice Ayush. I also thought it was very good.
It's the Worksheet-Function equivalent of putting comments after an apostrophe
in VBA.
Regards - Dave.
> Date: Wed, 17 Jun 2009 07:48:06 -0700
> Subject: $$Excel-Macros$$ Best Excel Tip Award of Week # 24 goes to HARMEET
> SINGH
> From: jainay
pls send the original sheet
2009/6/15 zheng yu
> hmm..anybody can make the macro work in the original sheet?
>
>
> On Fri, Jun 12, 2009 at 6:29 PM, zheng yu wrote:
>
>> Hey guys thanks
>>
>> but ..I copy the code into new sheet, and it works perfect too.. it is
>> just in that original sheet, i
Hi Ayush,
Thanks a lot
This is the charm of Excel Group that is attracting good talent.
Hope to help you all in future too with my knowledge.
Watch out for more [?]
Regards,
Harmeet
On Wed, Jun 17, 2009 at 8:18 PM, Ayush wrote:
> Hello Everyone,
>
> I am happy to inform y
Your example doesn't make sense... can you put a sample excel sheet of
what the data looks like in table and how you want it
On Jun 17, 5:00 pm, satish wrote:
> Dear Group members
> I feel the following query is challenging. Is it possible to find a solution
> without macro (as am weak in macro)
This can work only through a macro...
On Jun 17, 4:23 pm, Jack wrote:
> Hey anyone know how to make all of my hyperlinks open in read only ???
> Cheers
--~--~-~--~~~---~--~~
-
Some
The only reason would be that "prtPt_u1>0" is evaluated to true. check
this
On Jun 17, 1:50 pm, mac160 wrote:
> I have altered a cell validation expression to include more criteria.
> The resulting expression is:
> =AND(OR(ISBLANK(inpNodeFlow_u1),ISBLANK(inpPtOverride_u1)),ptrPt_u1>0)
> When the
Excellent tip Harmeet... really enjoyed this...
On Jun 17, 7:48 pm, Ayush wrote:
> Hello Everyone,
>
> I am happy to inform you that the award of best excel Tip of Week # 24
> goes to Harmeet Singh. The tip submitted by Harmeet is as follows :
>
> Subject : Hidden text in Formula
> Tip : =20
Hello Everyone,
I am happy to inform you that the award of best excel Tip of Week # 24
goes to Harmeet Singh. The tip submitted by Harmeet is as follows :
Subject : Hidden text in Formula
Tip : =2018+1056-4*120+N("My Salary + Bonus - 4 weekly loan
repayments")
BY using *N() *formula You can
I am slowly learning Excel
Please let me know how I can post my questions regarding Excel Macros to
you.
--
Sathyan From MADURAI
Other ID:
kainoorsath...@hotmail.com
--~--~-~--~~~---~--~~
Hi all,
Need code to run batch file through Excel
Thanks and Regards
Bharghav R
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video a
Thankx a ton Paul It worked!
On Tue, Jun 16, 2009 at 11:11 PM, Paul Schreiner wrote:
> The problem is that, in your macro, you're changing the value of the
> cell... so that fires off the change event AGAIN.
> What I would do is, in the first line of the macro, add:
>
> Application.Enable
Hey anyone know how to make all of my hyperlinks open in read only ???
Cheers
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text
Great Just what i need many thanks for your help
Jack
On Jun 16, 9:35 pm, Phillip Swanepoel wrote:
> Hey...
>
> Sorry for late reply.
>
> Firstly i gota declare that i am still learning my self and there is
> probably "cleaner" and beter solution.
>
> This is what i came up with so long...
>
>
It doesn't look like that there are command-line switches that select the sheet.
The only way I KNOW of is to put it in a Workbook_Open event or Auto_Open macro.
If you don't "own" the file, you could create one of your own
that, when opened, opens the second file and selects the sheet.
paul
_
Hi Ruchi,
This query is related to the "linking of the files onto a excel
spreadsheet".
For example, you have some week - wise spreadsheets in your c drive (e.g.
C:\Ruchi\work). The files may have the names like (week4.xls, week5.xls,
week6.xls) and so on. Now what you want to do, is to link up
I have altered a cell validation expression to include more criteria.
The resulting expression is:
=AND(OR(ISBLANK(inpNodeFlow_u1),ISBLANK(inpPtOverride_u1)),ptrPt_u1>0)
When the expression evaluates to FALSE the cell still accepts an
entry. Part of the expression:
=OR(ISBLANK(inpNodeFlow_u1),ISB
Problem solved, thank you very much for your kind follow up.
Sent via BlackBerry Wireless
-Original Message-
From: Mahesh R
Date: Wed, 17 Jun 2009 10:20:44
To:
Subject: $$Excel-Macros$$ Re: Logo at opening
Hey Ahmet,
Is it working??
Thanks!!
On Wed, Jun 17, 2009 at 4:38 AM,
Hi all,
Need code to export excel data which is in 3 columns to flatfile.Have
attached files for your reference.I need code for this asap
Thanls in advance
Bharghav R
--~--~-~--~~~---~--~~
Hey Ahmet,
Is it working??
Thanks!!
On Wed, Jun 17, 2009 at 4:38 AM, Ahmet Yalcin wrote:
> Thank you...[?]
>
> 2009/6/16 Mahesh R
>
> Hi Ahmet,
>>
>> For that, you have to save the Excel file which contains the Company logo,
>> disclaimer into *C:\Documents and Settings\User\Application
>> D
30 matches
Mail list logo
