$$Excel-Macros$$ Conditioning formating problem with first weekday

2015-06-11 Thread Maciej Piotrowicz
hello Experts While using conditioning formating on dates with option next week in default excel has sunday as a first day. I know I can use formula weekday there but I am looking for global option to simplify that. How to set Monday as first day of week globaly? In Excel or even in Oparating S

$$Excel-Macros$$ VBA code question !!!

2015-06-11 Thread Mandeep Baluja
Question mentioned is in between the code Sub Get_unique_pincodes() With ActiveSheet lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row lc = .Cells(1, Columns.Count).End(xlToLeft).Column Debug.Print lc lc = lc - 1 For i = 4 To lc .UsedRange.AutoFilter field:=i, Criteria1:="1" .UsedRange.AutoFi

$$Excel-Macros$$ Re: Help for error :Excel help viewer has encountered a problem & cannot continue.

2015-06-11 Thread Michael Vinoth
Hi Rohit, Check this :- http://answers.microsoft.com/en-us/office/forum/office_2010-excel/has-anyone-come-across-an-the-help-viewer-has/45771784-b014-414d-b872-8304e1b99dae Regards, MV On Thursday, June 11, 2015 at 2:41:44 PM UTC+5:30, Rohit Jadhav wrote: > Hi > I'm not able to access any hel

$$Excel-Macros$$ Help for error :Excel help viewer has encountered a problem & cannot continue.

2015-06-11 Thread Rohit Jadhav
Hi I'm not able to access any help from Excel 2007. I have attached the error snap shot here. I tried reinstalling Excel but after sometime it comes back. I also downloaded latest updates from MS site but it did not make any difference. Has any one faced & solved this problem successfully. Als

Re: $$Excel-Macros$$ please help

2015-06-11 Thread Shabbir Mulani
hi, How i disable cut and paste in word 2007 file. On Mon, Jun 8, 2015 at 9:25 AM, Kumar Bhanushali < kumar.bhanush...@pmcprojects.com> wrote: > > *Dear Sir,* > > In attached file, Basic sheet is there. In that sheet I had created 4 > buttons, Namely, For RA, For Adhoc, Above, Below. > With whic