$$Excel-Macros$$ MS Access Group

2013-08-10 Thread Kaushal Kumar
Hi All, Is there any such group for MS Access and SAS as well ? Rgds, Kaushal -- 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 FORUM RULES 1) Use concise,

$$Excel-Macros$$ Re: saving unique values from a dependant combobox to a sheet

2013-08-10 Thread Ricardo Fourie
attached please find the sample workbook. as you can see in the sample i used a listbox to show the unique numbers, but that does not need to be. regards On Friday, 9 August 2013 22:48:19 UTC+2, Ricardo Fourie wrote: good day i have a source sheet and a resultant sheet. i have a form with

Re: $$Excel-Macros$$ MS Access Group

2013-08-10 Thread Anoop K Sharma
Join such groups on FB On 8/10/13, Kaushal Kumar kaushal.anal...@live.com wrote: Hi All, Is there any such group for MS Access and SAS as well ? Rgds, Kaushal -- 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

$$Excel-Macros$$ Re: saving unique values from a dependant combobox to a sheet

2013-08-10 Thread Ricardo Fourie
thank you for your assistance. this thread is now solved. also here http://www.excelfox.com/forum/newreply.php?do=postreplyt=1353 On Friday, 9 August 2013 22:48:19 UTC+2, Ricardo Fourie wrote: good day i have a source sheet and a resultant sheet. i have a form with comboboxes on which gets

$$Excel-Macros$$ Auto Sum by List- HELP PLZ

2013-08-10 Thread SAJID MEMON
Dear Experts,First I would like give heartly wishing you EID-MUBARAK to all of you,I am attached my query please solve my problem.Awaiting your reply RegardsSajid Memon -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Auto Sum by List- HELP PLZ

2013-08-10 Thread Prafull Jadhav
SAME TO YOU...Happy EID. Please let me know ..Whole Range sum of D column is less then Cells B9 then output will in F Column,. Please check excel sheet . Please let me know if any further changes . Regards, Prafull Jadhav. On Sat, Aug 10, 2013 at 7:02 PM, SAJID MEMON sajidwi...@hotmail.com

$$Excel-Macros$$ how to clear all values and properties in a sheet

2013-08-10 Thread Prabhu Pinky
hi experts, pls gimme the macro for clear all the contents, values, properties in a excel sheet. (for ex: sheet1 entire cells) Thanks Regards, Prabhu R -- 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

Re: $$Excel-Macros$$ how to clear all values and properties in a sheet

2013-08-10 Thread ashish koul
Sub tes() Sheets(1).UsedRange.Clear End Sub On Sun, Aug 11, 2013 at 11:16 AM, Prabhu Pinky prabhupin...@gmail.comwrote: hi experts, pls gimme the macro for clear all the contents, values, properties in a excel sheet. (for ex: sheet1 entire cells) Thanks Regards, Prabhu R -- Are you

Re: $$Excel-Macros$$ how to clear all values and properties in a sheet

2013-08-10 Thread Prabhu Pinky
wow great.. thanks ashish.. Thanks Regards, Prabhu R On 11 August 2013 11:23, ashish koul koul.ash...@gmail.com wrote: Sub tes() Sheets(1).UsedRange.Clear End Sub On Sun, Aug 11, 2013 at 11:16 AM, Prabhu Pinky prabhupin...@gmail.comwrote: hi experts, pls gimme the macro for clear