Hi ashish,
your suggestion is really awesome,
but this code was not working please suggest how to use this
code.
or please share the workbook
thanks,
On Saturday, 16 March 2013 20:01:32 UTC+5:30, ashish wrote:
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
On Error GoTo ERR:
Application.EnableEvents = False
Dim I As Long
I = Application.WorksheetFunction.Match(Me.Cells(Target.Row, 1).Value,
Sheets(Me.Cells(1, Target.Column).Value).Range("A:A"), 0)
If Not Inte
i mean that is there any way to searched result cell should be appear in
the top of the page while clicking the cell.
but your formula result was appearing in the bottom of the page.
and i don,t want to show the formula in the cell. i am expecting VBA code
for that.
but anyway your answer is
Hi Ashish!
thanks for your valuble replay,
this formula was fulfilling my requirement a little. Please suggest much
better output.
thanks
On Sunday, 10 March 2013 12:06:55 UTC+5:30, ashish wrote:
> Try this formula see if it suffice ur requirement
>
> *
> =HYPERLINK("#'"&B$1&"'!a"&M
Try this formula see if it suffice ur requirement
*=HYPERLINK("#'"&B$1&"'!a"&MATCH($A2,INDIRECT("'"&B$1&"'!$A:$A"),0),"Click")
*
Regards
Ashish
On Fri, Mar 8, 2013 at 12:52 AM, Renukachari Kasee wrote:
> Dear experts,
> please solve the attached problem for search option using VBA
> please look
