RE: $$Excel-Macros$$ query need help

pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Sunday, March 16, 2014 8:02 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query need help Hi experts, please find the attached file. my query is. i want to

RE: $$Excel-Macros$$ query2

Pfa,, Type:=8 refer to range From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhu Pinky Sent: Sunday, March 16, 2014 12:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query2 hi experts, PFA, i have few names in sheet 1, my re

Re: $$Excel-Macros$$ Lock only column in vba

Hi please find below snapshot. i used sumifs formula and get value in cell D4 using VBA code as below. "=SUMIFS('Audit details'!$L$3:$L$54,'Audit details'!$H$3:$H$54,Sheet2!$B3,'Audit details'!$B$3:$B$54,Sheet2!D$2)" in which the yellow highlighted cell refers the agent AAA, when i run the macro

RE: $$Excel-Macros$$ Lock only column in vba

Hi Prabhu, You can use.. I = 1 Range("A1:A" & i) I = I + i === Cells(i ,"a") Use I counter to increment the row no. Hope it will help Thanks & regards, www.MrExcel4U.com From: excel-macros@googlegroups.com [mailto:excel-macr

$$Excel-Macros$$ Lock only column in vba

Experts How to lock only columns in vba...row reference should be change... I want to lock only column range -- 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 @ https://www.facebook.com/discussexcel FO

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Please check and ..let me know. Regards, Prafull Jadhav 9920553518 On 17 March 2014 21:12, Prafull Jadhav wrote: > Error status No Error ? C ? NC ? > > Error --How to find out Quality- how to find out > > Regards, > Prafull Jadhav > 9920553518 > > > On 17 March 2014 16:58, Prabhu Pinky

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Error status No Error ? C ? NC ? Error --How to find out Quality- how to find out Regards, Prafull Jadhav 9920553518 On 17 March 2014 16:58, Prabhu Pinky wrote: > can you workout and send me..i did tried.. but am not getting result. > > if you provide VBA code.. it would be so great. >

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

can you workout and send me..i did tried.. but am not getting result. if you provide VBA code.. it would be so great. Thanks & Regards, Prabhu R On 17 March 2014 15:51, wrote: > Y don't u use sumifs or countifs > Sent on my BlackBerry(R) from Vodafone > -- > *From

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Y don't u use sumifs or countifs Sent on my BlackBerry(R) from Vodafone -Original Message- From: Prabhu Pinky Sender: excel-macros@googlegroups.com Date: Mon, 17 Mar 2014 15:48:28 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Very urgent . i need to submit m

Re: $$Excel-Macros$$ Very urgent . i need to submit my project today.. please help

Am using excel 2007. On 17-Mar-2014 12:24 PM, "ashish koul" wrote: > which version of excel r u using > > > On Mon, Mar 17, 2014 at 12:22 PM, Prabhu Pinky wrote: > >> Guys...pls help with my query >> On 17-Mar-2014 9:22 AM, "Prabhu Pinky" wrote: >> >>> Hi Experts, >>> >>> Please find the att

$$Excel-Macros$$ Creating a popup "window" displaying messages from main program

Greetings I have created a code which takes a long time to run. The code has certain messages to be displayed in the window e.g. "CIRCULATION LOOP NUMBER _", "ANGLE OF ATTACK LOOP NUMBER _" etc. It must popup when the command button is pressed, and display the messages when prompted by the mai

Re: $$Excel-Macros$$ Need an address split up formula.....

Thanks Shahzad. On Mon, Mar 17, 2014 at 12:04 PM, Aamir Shahzad wrote: > Hi Indrajit, > > try this > > > =IF(ISERR(FIND("ACT",A4,FIND("ACT",A4)+1)),LEFT(A4,FIND("ACT",A4)-1),LEFT(A4,FIND("ACT",A4,FIND("ACT",A4)+1)-1)) > > > On Mon, Mar 17, 2014 at 12:32 AM, Indrajit $nai > wrote: > >> Thank