Recent content by pragnesh_50

Hi i have following macro which run in particlular book. but i want it to work at all the books of particalur folder. and want output in one file only Sub showcomments() 'posted by Dave Peterson 2003-05-16 Application.ScreenUpdating = False Dim commrange As Range Dim cmt As Comment Dim...

Hi, My Excel got hanged up due to heavy space. Could you suggest how i can remove unwanted space and reduce size? Regards, Prangesh

any updates please

Could you check https://rapidshare.com/files/1048222655/output_Cheese_Adhoc_6160.xls And do the needful for the above two request

Hi could you share you email id so that i can share my file to you. as i am no voice to micro could you just update my file like that for above two request

Hi , I want two things in my data validation file. 1. My drop down contains many values i want to quickly select values ex. I have values starting with A, B, C, D, X... I want to select values starting with X by pressing X ... same logic for all the other values. 2.New values in drop down...

I think the server will be excess by company employee only.

Hi I want to generate report form my company system. I think it can be automated by excel macro. Following are the steps to generate report: 1. Go to Link > http://10.6.33.22/onlinetools/mis/owb%20search/OWB%20Search%20with%20Assignment%20Details.asp 2. Enter Login ID & Password...

Hi Can any one suggest in excel Calander based on week where week start from Thursday to Wednesday. Like weeek1 Thu to wed weee2 ... Regards, Pragnesh

hi i got application define or object define error for clear contents statement regards, Pragnesh

HI, what if i convert all date in column A in to text format by having in B cell =TEXT(A1,"DD-MM-YY") and than convert it into Date. =datevalue(B1)?

Hi, Input Date should be interpreted as dd/MM/YY i.e., 2/12/2011 should be interpreted as 2nd February 2011.

Hi Narayan, When i pull all the data from various sheets it is difficult to identify correct date. because in every sheet different format are used (some are without any format just typing the date) like., 12/2/2011, 02/12/2011, 12-2-2011, Feb-12-2011 etc., So i am changing date format by...

HI Luck M, I am not able to judge where to put the above line in current macro. Could u just update the macro.

Hi, I have one shared book having different tabs from my team member. in every Sheet i got Dates written in various forms like,,,,2/12/2011, 12/2/2011, 12-2-2011 etc......data column is always A in every sheet I want to get uniform date format from all the tabs at once.