Hi Prafull,
we can create a hyperlink with a particular range or a static name range.
if you have a dynamic name range it does not show in hyperlink dialogue box
.
if you want to create a dynamic hyperlink follow these steps
1- create a name range which refers any cell like (a1 or a2 ...)--it is
try ths
http://www.mrexcel.com/forum/excel-questions/548342-embed-password-visual-basic-applications-odbc-connection.html
On Wed, Feb 26, 2014 at 7:59 PM, pranav patil wrote:
> I have created an Excel sheet that retrieves data from a ODBC source. I
> have created a macro using macro recorder to
Dear Priti Madam,
Very good morning,
Since morning i am trying to understand the hyperlink "Goto" name but i
don't understand .
Please explain me how you have hyperlink the same .
i got below points
1) what does the index and match formula in this sheets that is goto
2)Name - is used for data v
Ha, Paul found a typo in my code that solved my problem... phew!
On Tuesday, February 25, 2014 3:45:33 PM UTC-5, Sara C wrote:
>
> Hi,
>
> I'm using a VBA macro for an invoice for a service, where the price per
> hour of the service depends on 4 variables: location, type of worker, time
> of ser
Hi Friends,
I want to embed flash games in Excel 2007.
I have a flash game. It is to be noted that game's extension is exe, not
swf.
If it possible, please help me.
Thanx in advance,
Regards,
Waseem Saifi
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:
Greetings, all
What am I doing wrong here? I am trying to create an array from a range,
but keep getting the "Run-time error '9': Subscript out of range" warning.
TIP = Application.WorksheetFunction.CountA(ActiveSheet.Range("D19:D1048576"
)) 'Counts the number of active rows below the first as
Where did you place the
Private Sub Workbook_Open
macro?
(It belongs in the Thisworkbook module)
also, instead of having the user enter the version number, why not have the
macro READ the number?
(that is, unless the name of the original file (File A) changes)
also: what I have done is crea
Hi Amar,
it is simple index match formula and 1 indicates row number.
please go over this for more clarification.
https://sites.google.com/site/e90e50fx/home/Excel-Hyperlink-to-a-dynamic-range
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! J
Dear Madam,
I also trying the same but not able to understand the same.
It will be better if you explain the same...
Thanks in Advance ...Madam
Regards,
Prafull Jadhav
9920553518
On 28 February 2014 17:09, amar takale wrote:
> Dear Raviderji & Priti
>
> Thank very much for nice solution.
Dear Raviderji & Priti
Thank very much for nice solution.
Priti madam,can you explain me Define name formula.in which why we get
1,if change it then formula destroy link? And how to link this to
button.Pls explain me
Regards
Amar
On Fri, Feb 28, 2014 at 4:38 PM, priti verma wrote:
> you can al
you can also try this without vba
please see attach file.
On Fri, Feb 28, 2014 at 2:25 AM, Ravinder wrote:
> Thanks dear
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Prafull Jadhav
> *Sent:* Friday, February 28, 2014 3:44 PM
> *To:*
Thanks dear..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prafull Jadhav
Sent: Friday, February 28, 2014 3:44 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: Re: $$Excel-Macros$$ Hyperlink formula for horizontal Search
Great Ravinder Sir..
Hi Ravinder Sir,
OWSOME..!!!
On 28 February 2014 15:33, Ravinder wrote:
> PFA.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* Friday, February 28, 2014 3:18 PM
> *To:* excel-macros@googlegroups.com
> *Subject:
Great Ravinder Sir..
Regards,
Prafull Jadhav
9920553518
On 28 February 2014 15:33, Ravinder wrote:
> PFA.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *amar takale
> *Sent:* Friday, February 28, 2014 3:18 PM
> *To:* excel-macros@goo
PFA...
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of amar takale
Sent: Friday, February 28, 2014 3:18 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Hyperlink formula for horizontal Search
Dear All Experts
I required Hyperlink formu
Dear All Experts
I required Hyperlink formula for horizontal Search.If I show my criteria &
click then search that specific name in column means go to direct that
specific Column
Regards
Amar
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's
=TIME(2,DO:IT,N:OW) ! Joi
Dear Elis,
below software is not working & not showing the password can u find the the
password of attached file password.
please...
Regards,
Nitin Kumar
+91 9784363535
Pfa,
Regards,
Nitin Kumar
On Fri, Feb 21, 2014 at 6:08 PM, elis smith wrote:
> * You can use Excel file password creacker
17 matches
Mail list logo