Sorry I zsee I forgot my name
Thanks,
David Lanne
________________________________
From: David Lanne <djl99_28...@yahoo.com>
To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com>
Sent: Tuesday, November 15, 2011 1:09 AM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
Thanks for the guide, I'm trying to do something similiar to example 3 but I
can't seem to get my =getphoto cell (C3) to be a picture. Result comes up 0. I
can't seem to get my C3 to accept/format the pic.
My formula is
=indirect("Logos!B"&match('newspaper headlines'!$F$3,Logos!$A$:$A$,0)) My pics
are in col b of Logos and the Text to match is in col A.
________________________________
From: NOORAIN ANSARI <noorain.ans...@gmail.com>
To: excel-macros@googlegroups.com
Sent: Monday, November 14, 2011 10:04 PM
Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
Thanks Don,
I have removed all external name range link from file which were showing ref
error.
Aside to Nikhil : In Example 9 Form's Controls has used,which are not in excel
2003 so it is showing error. --
Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Tue, Nov 15, 2011 at 12:55 AM, dguillett1 <dguille...@gmail.com> wrote:
That example is using an external file so the defined name shows ref
>
>Don Guillett SalesAid softwaredguille...@gmail.com
>
>From: Nikhil Shah
>Sent: Monday, November 14, 2011 12:43 PM
>To: excel-macros@googlegroups.com
>Subject: Re: $$Excel-Macros$$ 10 Ways to Use Magical INDIRECT Function
>
>Dear Noorain
>
>Excellent Help.
>
>Example 9 - Sheet is showing some error...Can you rectify ?
>
>I am using Office Excel 2003.
>
>Thanks in advance
>
>Nikhil
>
>On Mon, Nov 14, 2011 at 11:58 PM, NOORAIN ANSARI <noorain.ans...@gmail.com>
>wrote:
>Dear Group,
>>
>>Please find attached Sheet to use 10 Simple way to use Indirect Function
>>example..
>>
>>if any one have more examples Kindly share with group.
>>
>>The Excel INDIRECT function takes a text string and converts this into a cell
>>reference.
>>Excel does not understand the text string "B1" to mean a reference to the
>>cell B1. Therefore, if you extract or build up a reference to a cell or range
>>using text, you will need to use the INDIRECT function to convert this into a
>>reference that Excel can understand.
>>The format of the function is :
>>INDIRECT( Ref_text, A1 )
>>
>>Where the arguments are as follows :
>>Ref_text - The text describing the reference
>>A1 - An optional logical argument that defines the style of the Ref_text
>>reference.
>>This can be either :
>>
>> * True - to denote that the reference is in A1 style
>> * False - to denote that the reference is in R1C1 styleIf this argument
>> is omitted, it takes on the default value "True" --
>>Thanks & regards,
>>Noorain Ansari
>>http://excelmacroworld.blogspot.com/
>>http://noorain-ansari.blogspot.com/
>>--
>>FORUM RULES (934+ 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 quick attention or may not be answered.
>>
>>2) Don't post a question in the thread of another member.
>>
>>3) Don't post questions regarding breaking or bypassing any security measure.
>>
>>4) Acknowledge the responses you receive, good or bad.
>>
>>5) Cross-promotion of, or links to, forums competitive to this forum in
>>signatures are prohibited.
>>
>>NOTE : Don't ever post personal or confidential data in a workbook. Forum
>>owners and members are not responsible for any loss.
>>
>>------------------------------------------------------------------------------------------------------
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>-- FORUM RULES (934+ 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 quick
>attention or may not be answered. 2) Don't post a question in the thread of
>another member. 3) Don't post questions regarding breaking or bypassing any
>security measure. 4) Acknowledge the responses you receive, good or bad.
>5) Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited. NOTE : Don't ever post personal or confidential
>data in a workbook. Forum owners and members are not responsible for any loss.
>
>------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>-- FORUM RULES (934+ 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 quick
>attention or may not be answered. 2) Don't post a question in the thread of
>another member. 3) Don't post questions regarding breaking or bypassing any
>security measure. 4) Acknowledge the responses you receive, good or bad.
>5) Cross-promotion of, or links to, forums competitive to this forum in
>signatures are prohibited. NOTE : Don't ever post personal or confidential
>data in a workbook. Forum owners and members are not responsible for any loss.
>
>------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com-- FORUM
>RULES (934+ 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 quick attention or may not be answered.
2) Don't post a question in the thread of another member. 3) Don't post
questions regarding breaking or bypassing any security measure. 4)
Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or
links to, forums competitive to this forum in signatures are prohibited. NOTE
: Don't ever post personal or confidential data in a workbook. Forum owners and
members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com-- FORUM
RULES (934+ 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 quick attention or may not be answered. 2) Don't post a question
in the thread of another member. 3) Don't post questions regarding breaking or
bypassing any security measure. 4) Acknowledge the responses you receive, good
or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. NOTE : Don't ever post personal or confidential
data in a workbook. Forum owners and members are not responsible for any
loss. ------------------------------------------------------------------------------------------------------To
post to this group, send email to excel-macros@googlegroups.com
--
FORUM RULES (934+ 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
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
