$$Excel-Macros$$ Re: Excel Interview Q & A

Hi Ayush, It might be of some help to you. 3 Things to remember before you go for Excel VBA Job Interview 50 Excel VBA Oral Interview Questions --

$$Excel-Macros$$ Re: Urgent help required in vba coding!!!!!!!!!!!!!!!!!!!!!

Quick reply for 2nd point: IN VBE, Select: Tools / VBA Project Propoerties / Protection Now enable "Lock Project for Viewing", enter password twice and click on OK. Most Imp: Do not forget the passowrd. regards, Milind On Mar 6, 3:52 pm, "Indrajit $nai" wrote: > Hi All, > > I need a urgent help

$$Excel-Macros$$ Re: Rename of files in specific format

*Replace* Characters in the Filenames of a Directory Hi Ankit, This is such a simple problem and hence the solution, that I don't need to provide long texts explaining that what it does. Simply, see the figure below and y

Re: $$Excel-Macros$$ Fwd: Help on formula

Hi Jorge, If you want to further reduce your formula size, you can use =IF(((P3>T3)+(Q3>U3)+(R3>V3)+(S3>W3))>=2,TRUE,FALSE) I only modified Paul's formula. So, Thanks Paul. -- Excel VBA Interview Questions

$$Excel-Macros$$ Re: Variant = Array ???

Hi Nihal, Variant is not working as array here. Moreover, it's logically incorrect to assign value of a range with multiple cells to a single variable. Since A is variant, it's not throwing any error at compile time but when you tried watching the value of A, it's not showing it. The only case

$$Excel-Macros$$ Re: ( ) for Array Must???

Hi Nihal, While declaring array () is a must, we can ignore the lower and upper bound in declaration statement but not the brackets as the brackets tells compiler to use the variable as array and leaving few spaces in the RAM which will be reconfigurable using redim statement. Declaring an arr

$$Excel-Macros$$ How to use OFFSET and SUM function together?

Create Excel Dashboard using OFFSET, SUM and MATCH functions As we learned in our previous article on OFFSET function, when we increase eithe

Re: $$Excel-Macros$$ help with formating

thanks Chilexcel From: ChilExcel To: excel-macros@googlegroups.com Sent: Fri, March 4, 2011 11:53:45 PM Subject: Re: $$Excel-Macros$$ help with formating with conditional formatting you just have to change% for conditions 1,2,3 chilexcel 2011/3/4 pawel

Re: $$Excel-Macros$$ Re: Ashish Koul : Most helpful Member

Heartiest Congratulation Ashish On Sat, Mar 5, 2011 at 1:20 PM, ashish koul wrote: > thank you all > > > On Thu, Mar 3, 2011 at 9:49 AM, Jenie wrote: > >> Congratulation Ashish... keep it up >> >> -Original Message- >> From: excel-macros@googlegroups.com [mailto:excel-macros@goo