Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-07-31 Thread De Premor
Are you sure ? i've been test and try the code, and it work for any other picture. Did you know how that code work ? let me explain a little /*) //the code is in blue, and green is my comment / *'This code will only executed before you double clicking on any cells / ranges on sheet* *Private

$$Excel-Macros$$ Urgent need Automation Test Engineer - McLean,VA

2015-07-31 Thread MADHU-GenuineItLlc
Hi Partner. Please send resume to ma...@genuineitllc.com *Title : Automation Test Engineer* *Location : McLean, VA* Job Description:- The application of knowledge, skills, tools, and techniques to the definition, planning and tracking of project activities to meet or exceed customer

$$Excel-Macros$$ SP CapIQ Macro Question

2015-07-31 Thread B.J. Merriewether
Hello All - I am new to coding but have an issue I'm looking to solve. With the help of a friend, I was able to successfully accomplish 80% of my goal. I have a list of ~1700 tickers that I have to run an analysis on. I have been using the CapIQ plug in to extract the data. While I have been

$$Excel-Macros$$ Urgent need Client in Chicago IL need Sr. Ab Initio Developer---Send me 10+ years resume only

2015-07-31 Thread MADHU-GenuineItLlc
Hi Partner, Please send resume to ma...@genuineitllc.com *Sr. Ab Initio Developer – Contract until Jan 2016-**Send me 10+ years resume only * *Location: Chicago, IL * *Job Description:* ETL Developer Senior / Architect role is expected to have experience working with Ab Inito tools

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-07-31 Thread Rashid Khan
Thanks for the quick response. It works only for 1.jpg and not for any other pictures. Kindly look into the code thanks once again. On Sat, Aug 1, 2015 at 12:00 AM, De Premor d...@premor.net wrote: Here is the code, you can make changes or experiment with it Private Sub

$$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-07-31 Thread prkhan56
I am using Excel 2010 I have a problem as shown in the attached sample data In the directory C:\Product\Pictures I have many files with the names shown in Column A under the Code group eg: 1.jpg, 2.jpg ….and so on The size of inserted picture should be of the same height and width of the cell

Re: $$Excel-Macros$$ Macro to Insert Pictures according to the Cell Value in Column A

2015-07-31 Thread De Premor
Here is the code, you can make changes or experiment with it Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) On Error Resume Next If Target.Column = 1 Then Target.Offset(0, 1).Select ActiveSheet.Pictures.Insert(C:\Product\Pictures\

Re: $$Excel-Macros$$ FORMULA REQUIRED

2015-07-31 Thread GENIUS
Thank you very much for your quick response, I really appreciate it. once again thank you for your help On Thursday, 30 July 2015 20:43:01 UTC+5, Pankaj Sharma wrote: use this =INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)) or if you don't want to see #N/A error so use

$$Excel-Macros$$ Macro

2015-07-31 Thread Izhar
I'm interested to learn the coding of macro, what is the best possible way to achieve this, I know a little a bit about the macros but not fully may be 10% out of 100% -- *Izhar Ul Haq* Cell# 009203069072597 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s