Search results

Hi, How to format the Height and width of the chart. (chart is pasting from excel to word). Sub ChartsToWord() Dim WDApp As Word.Application Dim WDDoc As Word.Document Dim iCht As Integer Dim Msg As String Set WDApp = CreateObject("Word.Application") Set WDDoc = WDApp.Documents.Add...

Hi, Please see the below table and advise how to do the vlookup if the values are partially matching. Regards Sreekhosh

Hi All, I am trying to export and excel report from a website. Website is opening with the report but i am receiving a run-time error '2147467259 (80004005)': Method Document of object 'IWebBrower2' failed. I am using Internet Explorer 9 Here is my code. Dim ipf, ie As Object Dim path...

Hi, When i am trying to sort the subtotaled data, excel prompts me to remove the subtotaling. Is there any way to sort the data after subtotaling. I am looking for macro to do the same. In my data i need to sort the revenue in descending order. That means high revenue earning Parent company...

Hi, I have a table containing more than 10 Headers. How to select and copy multiple headers at a time using macro. I need to copy below Headers from my table. Account Name, Cleint Name, Eng Number, Revenue. I am using below code for selecting single column header, Range("Table1[Account...

Hi, My data consisting of 4 country's revenue. Which chart is best for showing contribution of each country?. India - 40% China - 31% Nepal - 19% Japan - 10% Regards Sreekhosh

Hi, As per the below Macro if the file (CustomersData.xlsb) is readonly (it may using by another person) it will close and display the MsgBox says "try after sometime". But if it is closed by the person who accesed earler, I will get an alert "File is Now available for editing" Readwrite or...

Hi, How can we add two comparative measures in Bullet chart. I am using Bar charts as bullet chart instead of conditional formatting. I Need to compare Year To Date Sales with Target and Previous Year to Date Sales. Regards Sreekhosh

Hi, I have a report with two dynamic charts. I used PICTURE link to view both. But whenever I reopen the report these charts are not updating properly. One is gauge chart and another one is Bullet chart, for the bullet chart bullets are not moving and for gauge chart needle is not moving. But...

Hi, I am using the below code for sending a range as email body. But I recently added a chart also into the range but it doesnt work (chart is not displaying). I just try with disabling the following code in function [.DrawingObjects.Delete ]. then the an error message was displying in email...

Here "Raj" and "Sree" are duplicate value. I need to remove the No.1,2,3 and should keep No.5 and 6, that means the last updated values. Please provide a macro for this No| Name| marks 1| Raj| 0 2| sree| 0 3| Raj| 0 4| lena| 0 5| Raj| 15 6| Sree| 12...

Hi all, Somebody from another team unprotected my macro's recently. First i thought myself might have been forgot to protect it or somebody knows my password, then i again protected it with new password. After few days, it is seems to be unprotected again. Then i search in google for the same...

Hi, My mastersheet having 5 company names (A,B,C,D,E) and its transactions on date wise (suppose 10 txns each). I need a macro for filter the data with company names, copy the filtered data to a new excel file (paste as values) and save this new file with the selected company name (add...

Hi Team, Please see the uploaded file below, https://www.dropbox.com/s/bdl0c99xdba1iba/Margin%20Analysis%20Chart.xlsx In this I need to highlight (chart as dark red) bottom three values of margin. Thanks SReeKHosH

In on of my website there is no option to export the data into excel. I can only see a preview of it in ma website itself. Is it possible to export the data into excel using Macros?

How can we set Short-key for Private Sub Macro?

Range A1:A15 contains both numbers and text's. I need to delete the entire row which start with number. I tried with this one but it does not work: ==================== Sub Button3_Click() For Each cell In Range("A1:M15") If cell > "0" Then cell.EntireRow.Delete End If Next End...

I have a file with 20 names Starting from A1:A20. If i select "A1" (by mouse or cursor) I need to update the row Number of A1 ie "1" in C1.(Like form Control)..

What are the common techniques and formulas used for customer retention analysis? if any templates?