Search results

Hi Raymond, Try the below link and check the 2nd page of the thread. http://www.mrexcel.com/forum/excel-questions/603280-visual-basic-applications-embedding-picture-outlook-email.html

Hi roypabitra, Would you also upload your workbook to check this issue. It looks like the error is due to the missing/mismatch of the worksheet names. Uploading the file will help to spot the issue correctly.

Hi Raymond, Check this link which has a code to attach the pictures on Outlook. http://www.mrexcel.com/forum/excel-questions/603280-visual-basic-applications-embedding-picture-outlook-email-2.htm

Hi Narayan & Prakash, Please help me with this. I cannot upload a file or an image with the current environment I work in . So, please put in my changes explained below and try. With the file Prakash has uploaded copy Column A & B (Names and Phone Number being a header row ) to a new...

Brilliant, This time I will obey with you and will not ask. :D Searched around and found some more details on it. http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx

Thank you Narayan.. This means the URL works as expected. Let me work around and give Prakash a complete version for his need.

Hi Prakash, Try the below link and check if you can download any file or gets any response result from it. Let me know, if this works as I can get on to automating it. Security settings on my PC is preventing it to be downloaded. Give a try please...

Hi Sudipta, You get the Combobox when you double click on a cell and that allows you to enter the text and it acts as as suggestion & autocomplete tool to help you to search your desired list value. Are you aiming at something different? Is that something like an Autofilter option what you...

Hi Prakash, Did you check out the API technical document from the website which states about How to use the API from there. You dont have to get any code downloaded from the website but can have a VBA function which prepares the API string and pass on to the website to fetch the results. YOU...

Hi Sudipto, Check this site. This talks about your requirement. http://www.contextures.com/xlDataVal10.html

Hi Prakash, The website holds the API functions written in Java, PHP and C#.Net. I doubt you can integrate any of these into VBA directly, unless you workaround these codes build an XLL and use it just like any Excel addin. This requires lot of expertise to make these work with Excel...

SirJB7, Ingoring your PS cost me (but not much though), managed to crash Excel with the downloaded addin. But this is awesome addin to nest the formulas. I will rely on this hereafter, if I want to analyse any formulas copied from others. Also, the nested formula from this addin cannot go into...

Thats a super super big formula and SMALLMAN too certifies it there :D.

Also, best part of that code is it nests your formula like any smart code editor which makes easily readable. We need to make more exercise on Alt+Enter to get the same.

Xiq, Yes. (Alt + Enter) does the same. But we turn lazy enough to do it manually when the code does that job for you. :D

@SirJB7, Thanks again for that link. I had gone through the link, used the addin from the site (though there is an issue with the link to the updated version). I will tell you, code in there is out of my reach. Fantastic coding by Rob. Thank you Rob. The addin does a good job of split &...

@SirJB7 : Thank you. I will go through the reference links and come back to you for any clarifications. @Shrivallabha : J-Walk's mega formula is a great tip to construct the big formulas. I will try it out too. Thanks for sharing it. Otherwise, Can API functions/.Net features do anything...

Prakash, Sorry for this, but am still not clear. Is that the code not working or you are not able to create the new DV lists?

Thanks DEB and Faseeh, Its our Formula challenge crackers I was trying to analyse on the Formula evaluation window and was not able to see the results of the formula expansions in one view. Hence the request came up. It is one feature in Excel widely used but Microsoft has never shown...

Hello All, Is there a way we can expand the Formula Evaluation window in Excel? This is for sure a great addition in Excel but has a drawback with a smaller display, if you want to evaluate the results on a bigger formula. Any alternates/customized addins available over web to show this a...

Narayan, Excellent explaination on the formula split up. Thank you.

Hi Prakash, Is this line of code failing for you? If WorksheetFunction.CountIf(Range("Fruit"), Target) = 0 Then 'New Name If Yes, thats because the range "Fruit" is defined in the worksheet, "Updating Validation List". You cannot refernce the named range from the other worksheet directly as...

Hi Prakash, How are you shifting the DV lists to another sheet? Drag and drop , Copy Paste? and also which correct formulas are you referring about?

Hi Madocar, Check the Pagesetup of the Excel file + Printer PaperSize settings. Change the PaperSize on the PDF printer and give a try. It should work.

Hi Lwilt, Would you upload the file to check the issue. That should help you to get the quick responses. Thanks.