Re: $$Excel-Macros$$ Protect unprotect query

hey you missing additional control.. Your cells are not locked, lock then protect.. Cheers//Vabs On Sun, Jun 30, 2013 at 3:44 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi Experts, I have assigned the macro to attached file for protect and unprotect the sheet manually. But it is not

Re: $$Excel-Macros$$ Re: Formula require

Thanks Mr Vijay, Using -- operator, I am able to convert Numeric Characters to Numeric value. (Example : entered =--a1 in cell A2 to convert the character contents from cell a1). Similerly, is there any similler operator is available to convert it back to character except single / double Quote.

Re: $$Excel-Macros$$ mail massage from worksheet

PFA, i've change your path to fit in my computer, change it back to your saving data directory Set fld = fso.getfolder(B:\Learn\FSO) Also in Cell E3, fill with correct path and file name Rgds, De Premor On 28/06/2013 19:10, Satendra kumar wrote: hi sir,, please find attachment i have need

$$Excel-Macros$$ Validation through Macro!!!

Hi All, PFA. I want to create the validation through Macro, can the EXPERTS help me on this? Requirement is on the 1st sheet and the Table data is on the 2nd sheet. Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and

Re: $$Excel-Macros$$ Question about function

Change the formula in J2 from =F2G2H2I2D2 to =F2G2TEXT(H2,dd/mm/)I2D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column numbered F. Question 2: In column J, How to connect string (F G H I D), without losing

$$Excel-Macros$$ RE: Macro Staff Hierarchy

HI all, Is it possible to do the attached in Vba / Macro. Any help would be appreciated Dii -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Question about function

Another suggestion would be to put the following formula in cell E2 and copy down. =COUNTIF($C$2:C2,C2). (TEXT(B2,dd/mm/)) - D2 Delete the columns to the right of column E On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the

Re: $$Excel-Macros$$ Question about function

If the countif function is not available to you, the following formula should work in cell E2 and copy down. =SUMPRODUCT(--($C$2:C2=C2)). (TEXT(B2,dd/mm/)) - D2 On Sun, Jun 30, 2013 at 3:17 PM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Question 1: I need one function to the column

Re: $$Excel-Macros$$ Question about function

istied using SUMPRODUCT, we can also use SUM with CSE {=SUM(--($C$2:C2=C2)) . (TEXT(B2,dd/mm/)) - D2} Rgds, [dp] On 01/07/2013 7:33, Norman Cliff May wrote: If the countif function is not available to you, the following formula should work in cell E2 and copy down.

$$Excel-Macros$$ Thought you'd find this interesting

Hi! I’ve just learned about the water crisis and thought you would be interested to check out this story: https://waterforward.charitywater.org/et/qgN1rodl Thanks, raghu -- Sent via WaterForward, an initiative of charity: water WaterForward, 387 Tehama Street, San Francisco, CA 94103,

$$Excel-Macros$$ Need Help to lock cursor or sheet display.

Dear Seniors, I have a data from Colum A to Column D in excel sheet, I want show only this data in sheet rest of sheet will be deleted and cursor will be working only from Column A to Column E. like in JPEG image attached. kindly find the attachment for refrence. Thanks, Ashish -- Are

$$Excel-Macros$$ Dependent Data validation with Dynamic name range!

Dear Excel expert! I am stuck at a point! I have kept five dynamic name range using offset funtion viz Grouping which has a component like liabilities, asset, income and expenses. And also have created dynamic name range for all of the components! My name range are working perfectly when I am