RE: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-22 Thread Asa Rossoff
ed) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hanumant shinde Sent: Thursday, December 22, 2011 9:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Return More than 1 value from Function Thanks a lot Asa, I thin

Re: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-22 Thread hanumant shinde
sorry i didnt understand what you mean.   can somebody please help me with this. From: dguillett1 >To: excel-macros@googlegroups.com >Sent: Wednesday, 21 December 2011 9:33 PM >Subject: Re: $$Excel-Macros$$ Return More than 1 value from Function > > >homework?? > &g

Re: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-22 Thread hanumant shinde
Thanks a lot Asa,   I think this might be some what smilar to class thing. just a guess     From: Asa Rossoff >To: excel-macros@googlegroups.com >Sent: Thursday, 22 December 2011 3:04 AM >Subject: RE: $$Excel-Macros$$ Return More than 1 value from Function > > >I won't t

RE: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-21 Thread Asa Rossoff
I won't tackle classes right now, but here are a couple more methods: 4. User-Defined Data Types 5. Collections Here's a user-defined data type example: Type ContactInfo Name As String Address As String End Type Function WhoAmi() As ContactInfo With WhoAmi .Name = "Samwi

Re: $$Excel-Macros$$ Return More than 1 value from Function

2011-12-21 Thread dguillett1
homework?? Don Guillett SalesAid Software dguille...@gmail.com From: hanumant shinde Sent: Wednesday, December 21, 2011 3:08 PM To: Excel Group Subject: $$Excel-Macros$$ Return More than 1 value from Function Hi, How can we return more than 1 value from 1 function. 1. using array 2. using By