Paul, I got sidetracked with another VB nightmare, but wanted to say
It worked (and taught me something)!
THANK YOU! THANK YOU!
On Jan 16, 10:08 am, Paul Schreiner wrote:
> Let me put on my "teacher" hat and see if I can help.
> When you look in the VBA editor, in the Project Explorer, you see
Consider using the ROUND, ROUNDUP or ROUNDDOWN functions
On Thu, Jan 22, 2009 at 4:36 AM, Kamran Haider
wrote:
> Dear Group mates,
>
> Please help me on round formula as xl built in formula round the figure on
> general math rule i.e 25.5 to 26 and 25.4
> to 25 whereas i want to work this form
Your question is confusing. Are you sure wht you want to do. However,
mentioned below are few suggestions which you can follow and whatever suites
you best
24.79 round(24.79,0) will return 25
if you want it to return you the lowest integer before 24.79 then use
INT(24.79) which will return 2
I tested this:
Sub Test()
Application.DisplayAlerts = False
On Error Resume Next
Err.Clear
Set wkb = Excel.Workbooks.Open(Filename:="C:\temp\test.xlsx" _
, ReadOnly:=True, Password:="password")
If (Err.Number > 0) Then
MsgBox "Could not open"
End If
Sure, you can do it without a macro.
if you want a space with the comma,
just use ", " instead of just the ","
=CONCATENATE(A1,",",A2,",",A3)
- Original Message
> From: Tobi Hammet
> To: MS EXCEL AND VBA MACROS
> Sent: Thursday, January 22, 2009 5:05:38 AM
> Subject: $$Excel-Macros
You should be able to use:
=ROUND(A1-0.3,0)
Paul
From: Kamran Haider
To: vba
Sent: Thursday, January 22, 2009 4:36:11 AM
Subject: $$Excel-Macros$$ Round figure
Dear Group mates,
Please help me on round formula as xl built in formula round the figure on
gene
Where to begin?
first, it's hard to do much since we don't know what the values of
rc1 and JobNumber are.
Second,
the first arguement for Vlookup is the lookup value.
You're taking the first (4) characters of rc1,
adding a "2", then the last characters of rc1, skipping the first 5.
followed by a
Dear Group mates,
Please help me on round formula as xl built in formula round the figure on
general math rule i.e 25.5 to 26 and 25.4 to 25 whereas i want to work this
formula in the way dat if i entered figure which value after decimal sign is
greater than 79 then it would round the figure
Thanks, that works great!
On Jan 21, 3:19 pm, Paul Schreiner wrote:
> Ok, first of all, the sub should be a change event, so that it is triggered
> when you make a change to the worksheet.
>
> Second, You really don't need the cdate function.
>
> Third, I would recommend that you use the Applica
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?
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.ex
10 matches
Mail list logo
