$$Excel-Macros$$ Date format system using VBA

Hi, I am copying the date as text from one sheet and pasting to another sheet using the code activesheet.paste. when i do it so, it is converting to general number 41135. after formatting to d/mm/, the date that is having greater than 12 get converted exactly to d/mm/ where as date tha

$$Excel-Macros$$ Excel rename file in folder

Hi, I have 150 files in my folder and all my files to be renamed starting with A using VBA macro. Example : if the file name is ABC it is to be replaced with A-ABC similarly if the file name is XYZ and is to be replaced with A-xyz. Thanks, Vishwa. "CONFIDENTIALITY NOTICE: This message and any

$$Excel-Macros$$ Duplicate line based on column

HI, In the attached excel, I need to remove the duplicate lines based on the "Column E". Example: The first line and the second line have same value in the "Column E". The first line should remain same and second line should be deleted, no matter what the other cell value has in the same lin

$$Excel-Macros$$ Bar Graph

Hi, Can you provide me the bar graph for the below data. Volumes & Time Spent Process Name Volumes Time Spent Weekly Product1 11 17:36:01 1 Product2 18 64:31:41 1 Product3 1 0:48:34 2 Product4 5 2:33:21 1 Product5 15 3:30:05 1 Product6 5 2:04:13 1 Product7 1 0:11:00

RE: $$Excel-Macros$$ Calendar - Quarterly

Subject: Re: $$Excel-Macros$$ Calendar - Quarterly pfa On Sat, Oct 27, 2012 at 3:06 AM, Viswanathan Yoganathan mailto:viswanathan.yoganat...@asia.xchanging.com>> wrote: HI, In the first column we have is year, based upon the month of the year it should fix into 4 quarters as shown in the

$$Excel-Macros$$ Calendar - Quarterly

HI, In the first column we have is year, based upon the month of the year it should fix into 4 quarters as shown in the below example. Year Qtr1 Qtr2 Qtr3 Qtr4 2/7/1990 Feb 5/13/1989 May 6/28/1989 June 7/27/1991 July 1/19/2012 Jan Let me know if

$$Excel-Macros$$ Macro Not working in shared Work Book

Hi, I am getting the below error if I run the macro in a shared and protected workbook. 'Run time Error 1004 unprotect method of worksheet class failed' Do we have any solution to overcome. Thanks, Vishwa. "CONFIDENTIALITY NOTICE: This message and any attachment are confidential and may also

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

ot; Or Application.WorksheetFunction.Text(rng.Value, "DDD") = "Sun" Then rng.Value = "" End If Next End With rngData.SpecialCells(xlCellTypeBlanks).EntireRow.Hidden = True End Sub Regards Prince Dubey On Wednesday, 27 June

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

Hi, I need the date should be like how I arranged in the column B. Thanks, Vishwa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vish Sent: Wednesday, June 27, 2012 1:19 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Delete Blank

RE: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx

Saturday and Sunday From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Vish Sent: Wednesday, June 27, 2012 1:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Delete Blank Cells.xlsx Hi Vishwa, By Weekends you mean Saturday and Sunday or

$$Excel-Macros$$ Delete Blank Cells.xlsx

Hi all, In the attached excel, I want to delete the week ends whereas at the same time the position of the month should not move. It means the Feb month should start from A34, March month should start from A64. Please advise using VBA macro. Thanks, Vishwa "CONFIDENTIALITY NOTICE: This messag