$$Excel-Macros$$ Taking offset of all the duplicate values - HELP!!

2009-12-28 Thread Ashish Sharma
--- On Tue, 29/12/09, Ashish Sharma wrote: From: Ashish Sharma Subject: Taking offset of all the duplicate values - HELP!! To: excel-macros@googlegroups.com Cc: excel-macros@googlegroups.com Date: Tuesday, 29 December, 2009, 3:53 AM Hi Group,   I am working on an Excel calendar where I

$$Excel-Macros$$ Taking offset of all the duplicate values - HELP!!

2009-12-28 Thread Ashish Sharma
Hi Group,   I am working on an Excel calendar where I need to take the offset value for all the duplicate values.   I am using the these two functions to get the first two values but if I want to have others values what function/formula should I used. ANY HELP would be a great help   1) =MATCH(C

$$Excel-Macros$$ indexing with custom collection

2009-12-28 Thread WildBil
If I use a standard VBA collection, I can avoid the use of collection.item(2).name and instead use collection(2).name on the other hand, if i create a collection as a class module I seem to only access data through collection.item(2).name and not through colle

$$Excel-Macros$$ Loop with If(and(

2009-12-28 Thread Michael
Hi group, I am new to this macro stuff and I was wondering if anyone would be able to tell me how to write code that would check down 1 column of data to see if (AND(the cell is empty, the next cell below it has data in it),then pop up a message box that says "Blank space dedtedted", else do nothi

$$Excel-Macros$$ Re: List of available fonts

2009-12-28 Thread Vishal Parihar
hello list of font in xp Arial Arial Black Arial Bold Arial Bold Italic Arial Italic Comic Sans MS Comic Sans MS Bold Courier 10,12,15 Courier New Courier New Bold Courier New Bold Italic Courier New Italic Estrangelo Edessa Franklin Gothic Medium Franklin Gothic Medium Italic Gautami Georgia G

$$Excel-Macros$$ Re: identifying duplicates

2009-12-28 Thread Dilip Pandey
Dear Steve, Yes, it would be helpful if you move both the list in same workbook, under two worksheets (Tabs). Let me know if you face any challenge. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062