Hi,
Does anyone know how to display the vlookup dialog box using vba?
Thanks.
--
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) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
U can use this coding also in single line
Sub Rectangle1_Click()
Application.SendKeys (%mfvlookup%g~)
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dr
Sent: Thursday, October 10, 2013 5:29 PM
To: excel-macros@googlegroups.com
Subject:
Very nice negi ji
Warm Regards,
Ravi Kumar.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Thursday, October 10, 2013 5:45 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Display Vlookup dialog box
Thanks.Ravi bahi..
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravi Kumar
Sent: Thursday, October 10, 2013 5:50 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code
Very nice negi ji
Hi Experts,
Please find below table for name and currencies:
Name
Currencies
Krishna
USD
Krishna
Rs
Harsha
Rs
Phani
Euro
Phani
USD
If name has multiple currencies I need to get answer as Multiple currency if
name has only one currency then answer should be single currency.
In
Hi Krishnaraddi,
Please see the attachment.
On Thu, Oct 10, 2013 at 6:53 AM, Krishnaraddi V. Madolli
krishnaraddi.mado...@asia.xchanging.com wrote:
Hi Experts,
** **
Please find below table for name and currencies:
** **
*Name*
*Currencies*
Krishna
USD
I don't know what PFA means. I can't view the attachment and sendkeys
isn't opening the dialog box.
On Thursday, October 10, 2013 8:14:56 AM UTC-4, ravinder negi wrote:
pfa
*From:* excel-...@googlegroups.com javascript: [mailto:
excel-...@googlegroups.com javascript:] *On Behalf Of
try this one too if thr are chances of duplicate records
On Thu, Oct 10, 2013 at 6:49 PM, priti verma pritiverma1...@gmail.comwrote:
Hi Krishnaraddi,
Please see the attachment.
On Thu, Oct 10, 2013 at 6:53 AM, Krishnaraddi V. Madolli
krishnaraddi.mado...@asia.xchanging.com wrote:
Hi
Here is my current code:
Code:
Dim sh As Worksheet, sh2 As Worksheet
Dim LastRow As Integer
Dim LastRow2 As Integer
Set sh = Sheets(Raw ATS Data)
Set sh2 = Sheets(ATS Data)
With sh2
Range(A2:H Rows.Count).Clear
End With
LastRow = sh.Range(A1).End(xlDown).Row
sh.Range(A1:H LastRow).Copy
can u pls share a sample workbook?
On Thu, Oct 10, 2013 at 9:05 PM, Justin Pulley maverick494...@gmail.comwrote:
Here is my current code:
Code:
Dim sh As Worksheet, sh2 As Worksheet
Dim LastRow As Integer
Dim LastRow2 As Integer
Set sh = Sheets(Raw ATS Data)
Set sh2 = Sheets(ATS
Was the attached file what you were looking for?
On Thursday, October 10, 2013 8:44:55 AM UTC-7, ashish wrote:
can u pls share a sample workbook?
On Thu, Oct 10, 2013 at 9:05 PM, Justin Pulley
maveric...@gmail.comjavascript:
wrote:
Here is my current code:
Code:
Dim sh As
De Premor -
My apologies for not responding sooner but I've been out of commission
It works perfectly :-D And I found that when I just copied and pasted the
images it works and seems to provide a bit more flexibility :-)
Would you mind explaining the macro you created, so that I'll be able to
Dear Anil,
I get an error Can't find the project or library , at the second line
Dim Myconnection As Connection,
during opening of the Autodropdown.xlsm file.
Regards
Eugene
On Fri, Sep 27, 2013 at 3:13 PM, अनिल नारायण गवली
gawlianil8...@gmail.comwrote:
Dear Pavan,
See the attached
Thanks Ashish.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: 10 October 2013 20:46
To: excel-macros
Subject: Re: $$Excel-Macros$$ currencies
try this one too if thr are chances of duplicate records
On Thu, Oct 10, 2013 at 6:49 PM,
14 matches
Mail list logo
