$$Excel-Macros$$ Re: Round figure

Yes Mr paul you r right problem is as you described it .Its good to see very experienced and helpy members .I would like to thanks to this group owner that provide us chance to meet such experience persons.Allah Hafiz ,Kamran Haider . Date: Fri, 23 Jan 2009 08:29:51 -0800From: schreiner_p...@a

$$Excel-Macros$$ Tip # 47 Opening multiple windows

Dear Members, A new tip of excel has been published on the blog . The title of the tip is "Opening multiple windows". Please visit the below link for this tip. http://exceldailytip.blogspot.com/2009/01/tip-47-opening-multiple-windows.html To see the archive of these Daily Excel Tips, Go to: htt

$$Excel-Macros$$ Re: collumn values -> list in cell seperated by kommas

use CONCATENATE Thanks & Regards On 1/22/09, Tobi Hammet wrote: > > > This does not have to be a makro, if its possible. > > Source: > > A1:5 > A2:7 > A3:7 > > what i want from this: > > B1: 5,7,7 > > (those values seperated by kommas) > > so can it be done without a makro? > > > > --~--~-

$$Excel-Macros$$ Re: collumn values -> list in cell seperated by kommas

A more general solution if you use a macro: Function ConcatRange(r As Range) As String Dim s As String Dim c As Range For Each c In r s = s & c.Value & "," Next ConcatRange = Mid(s, 1, Len(s) - 1) End Function Tom On Fri, Jan 23, 2009 at 2:34 AM, TEAMPL wrote: > >

$$Excel-Macros$$ BeforeDoubleClick Inputbox Entry formula

I have a BeforeDoubleClick input box requesting an integer from -9 to 9, then inputs that entry into the active cell. First, I need to prohibit the entry of a 0, 1, or -1 (Activate MsgBox indicating the user can't enter one of these and try again). Then I need to run a formula: If the number is

$$Excel-Macros$$ Re: Round figure

You're welcome. I think the problem is/was in understanding that "normal" rounding is done at 1/2. 1.50 rounds to 2, but 1.4 rounds to 1. YOU, however wanted the rounding point to be .8 So, the solution was to have excel shift the number by .3 to allow Excel to use the standard rounding functi

$$Excel-Macros$$ Re: Round figure

Thanks to every one who help me on below issue though every one has the unique way that realy add my knowledge. Mr Paul thanks a lot your solution absolutely solve my problem .Allah Hafiz ,Kamran Haider . Date: Thu, 22 Jan 2009 05:41:36 -0800From: schreiner_p...@att.netsubject: $$Excel-Ma

$$Excel-Macros$$ Calculate invoice about to due in a week...

Dear All, Please find attached file. My problem is self explanatory if you see the file. Thanks in an advance. Regards, Viral Pandya --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group,

$$Excel-Macros$$ Re: How to unhide the sheet

thanks.. On Jan 21, 10:14 pm, VIRAL PANDYA wrote: > I m just an end user but if any one know > please help this man with default file name for MS excel. Like NORMAL.DOT > for Microsoft word. > > Open the default file for excel and unhide from VBA mudule... it may be very > hide... (-1) f

$$Excel-Macros$$ Re: collumn values -> list in cell seperated by kommas

if you want it done macro range("b1") = range("a1") & "," & range("a2") & "," & range("a3") On 1월22일, 오후7시05분, Tobi Hammet wrote: > This does not have to be a makro, if its possible. > > Source: > > A1:5 > A2:7 > A3:7 > > what i want from this: > > B1: 5,7,7 > > (those values seperated by ko

$$Excel-Macros$$ Re: Different behaviour between opening xls and xlsx files

I believe this is enhance security in MS Excel 2007. Regards, Sarfaraz Ahmed Free MS Excel help On Thu, Jan 22, 2009 at 10:19 AM, Wazza wrote: > > I have an application that opens Excel files and loads data into an > Access database. This app runs unattended an

$$Excel-Macros$$ Re: Round figure

That's was good common sense... I really really appreciate Regards, Sarfaraz Ahmed MS Excel help On Thu, Jan 22, 2009 at 7:11 PM, Paul Schreiner wrote: > You should be able to use: > =ROUND(A1-0.3,0) > Paul > > -- > *From:* Kamran Ha