Search results

thank you Narayan. sorry for the late reply. I have already gone through these links... Adding a chart in the message body is very tough task.. I chnagd ma mind..:( and started to send that chart as attachement in JPG format. Thanks Sreekhosh

Thanks SirJB7 Yes SirJB7, you are right it is not as simple as i expected. Today i tried another method, I saved the chart as JPG in a folder. and added to the HTML body (using <img Src="chart.jpg">). It works fine and displayed in the email but the thing is when ever i change the...

Somebody Please Help??????

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...

Is it possible in a dynamic Data Range? I Have one Line chart which shows the daily achievemnt. I set the chart range as dynamic Chart Range based on the date value. Is there any way to show the data label only the last data poit automatically?

Thank you very much shrivallabha and Luke M

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...

=========C*O*N*G*R*A*T*U*L*A*T*I*O*N*S Chandoo...

I think kaushik03 will be one Option. another may be Debraj Roy

(((((****)))))))Congratulations Faseeh(((((****)))))))

Congrats HUI..thanks alot.

Just try this formula, =if(countif($a$1:$a1,a1)>1,a1,'''') Regards Sreekhosh

Yes, you helped me to accept the reality with a Smiling face :) "A dream doesn't become reality through magic; it takes sweat, determination and hard work." - Colin Powell Regards Sreekhosh.AP

"kids and dogs are more intelligent each day" that is absolutely right SirJB7!!!!thanks for the (wiki) information also. Thanks for the update LukeM and MarcL Regards Sreekhosh.AP

Thanks KK, Any other suggestions? Regards Sreekhosh

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 shrivallabha, Yes, this is the exact code which i need actually, thanks a lot man. Regards Sreekhosh.

Hi KPJ, Wow its really amazing Man. Thank you so much!!! Regards Sreekhosh

Hi Bobhc, Congrats Man... as expected..Keep up!!!!!!!!!! Regards Sreekhosh.AP

Thanks Luke and Hui, Please correct the below . Sub Macro1() Windows("Customer No Extraction.xlsb").Activate Sheets("Not Updated").Select Range("a1").Select '=======FILTERING======= For i = 0 To 5 fcr = Array("A","B","C","D","E")...

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 Ashl, See the chart2, https://www.dropbox.com/s/d2jbifr3cobtz1a/Sample2%20%282%29.xlsb Thanks Sreekhosh

Hi Injinia, I think you may have uploaded a different file. Thanks Sreekhosh

Hi Ashl, Please see the uploaded file. and please confirm is this you really need? https://www.dropbox.com/s/j52kwymjkxvkh0o/Sample2.xlsb Thanks Sreekhosh.

Hi Martina, Please see the uploaded file. https://www.dropbox.com/s/st1u88yor2np3um/Try.xls Thanks Sreekhosh