Re: $$Excel-Macros$$ Help me in this

Its works. Thanks Dave. On Sun, Apr 24, 2011 at 5:50 PM, Dave Bonallack wrote: > Hi Yogesh, > I only have one other idea to stay with your worksheet functions. All your > Countifs functions contain whole column references. > > eg: =COUNTIFS(DB_Sheet!*$D:$D*,$A16,DB_Sheet!*$E:$E*,K$2,DB_Sheet!*$B

Re: Re: $$Excel-Macros$$ How to Separate Text and Nos in a sentence ?

with the arrayformula: text in A2 definited name rng =OFFSET(Foglio1!$A$1,,,50,50) in B2: =MOD(LARGE(ISERROR(--MID("a"&SUBSTITUTE($A$2,".","0"),ROW(rng),1))*ISERROR(--MID(SUBSTITUTE($A$2,".","0"),ROW(rng)+COLUMN(rng),1))*IF(ISNUMBER(--MID(SUBSTITUTE($A$2," ","#")&"#",ROW(rng),COLUMN(rng))),90-ROW(

Re: $$Excel-Macros$$ How to Separate Text and Nos in a sentence ?

Hi Thanks for the formula. It does help, but while trying it on a new sheet its not working it gives an error #NAME? On Apr 19, 9:07 pm, ashish koul wrote: > see if it helps > > > > > > On Tue, Apr 19, 2011 at 7:14 PM, karan kanuga wrote: > > Hi, > > > Can any1 pls let me know how do i separate

Re: $$Excel-Macros$$ Remove Password Protection

see this link http://sites.google.com/site/chilexcel/desbloqueos-y-removepass break the password books, Sheets VB proyect 2011/4/22 Prakash Gusain > Hi, > > Can any one provide me any code using which I can break the password > of any excel add in? > > Prakash > > -- > >

Re: $$Excel-Macros$$ help..

That spreadsheet is proprietary document and password cant be shared to others. :( On Fri, Apr 22, 2011 at 9:44 PM, STDEV(i) wrote: > then you have to ask to the author of the spreadsheet > > > > On Fri, Apr 22, 2011 at 10:19 PM, vamsi varma > wrote: > >> dear friends, >> >> i need some help..

$$Excel-Macros$$ A VBA Challenge.. (Arrays)

Hi Guy's Need your help in this code.. in the following code... Sub Time_Test_Array2() Range("K1") = Now() Application.ScreenUpdating = False Range("E:E").Clear LastRow = 0 LastRow = Range("A100").End(xlUp).Row iVal = Range("A1:A" & LastRow).Value ReDim strArray(1 To UBound(i

Re: $$Excel-Macros$$ Show full screen for a particular workbook only.

Hi Paul, Thanks for the answer I checked the same idea before I sent the message, I give the fullscreen code when the work book open, but when I give the code for display screen normal when work book deactive it is not working as we think.that's why I posted it.Will u pls send attached sheet with t

RE: $$Excel-Macros$$ Help me in this

Hi Yogesh, I only have one other idea to stay with your worksheet functions. All your Countifs functions contain whole column references. eg: =COUNTIFS(DB_Sheet!$D:$D,$A16,DB_Sheet!$E:$E,K$2,DB_Sheet!$B:$B,$A$74) Since none of your DB_Sheet data goes beyond row 288325, you could change EVERY f

RE: $$Excel-Macros$$ macro to add fill color to a column of selected range

Hi, Something like: Dim c as Range For each c in Selection If c.Column = 6 then c.Interior.Colorindex = 3 Next c Note: Colorindex 6 will give you red. Change the number to suit. Regards - Dave. > Date: Sat, 23 Apr 2011 14:17:08 -0700 > Subject: $$Excel-Macros$$ macro to add fill color to

$$Excel-Macros$$ macro to add fill color to a column of selected range

I have a ~500 rows of data in columns A-G. Several contiguous rows of this data (columns A-G) will be selected. I would like my macro to fill column F of the selected cells with color without losing the original selection because these selected cells are used later in the macro. I've been able

Re: $$Excel-Macros$$ Help me in this

Thanks Dave, for your suggestion. but problem is that i want to update all sheets on daily basis. If i'll do this, it also be take same time. If you have any other idea please share with me. I am also working on it if i will get any solution then i will tell you. Thanks & Regards Yogesh Gohil On