I jsut wish keeping it simple was a option open to me
The reason it is a complex spreadsheet is because it has to be
automated for absolute morons to use on a daily basis - ie not being
able to put information in unless validated and in the correct format,
etc etc
Brian
On Feb 5, 4:43 pm, Anil B
Hi friends,
I wanna know if we can pass the variables without initializing them to any
other
function and get their values from that called function please find the below
example. which is similar to that of i have seen.
dim workingday as some data type
Sub calling ()
if not (calculateworkingd
You're welcome.
Dave.
> Date: Sat, 5 Feb 2011 20:31:35 +0530
> Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT
> From: rajeshkainikk...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi Dave
> Excellent work, I never thought that the conversion can be done by formula.
> Regar
"I have created a complex spreadsheet...
..
Can anyone point me in the right direction"
Right Direction : Don't Create complex worksheet, keep life simple :-)
Regards, Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
-Original Message-
From: excel
suppose your email ids are sdtored in sheet 1 and column 1
it will concatenate all the email ids
For i = 1 To Sheets(1).Range("a1").End(xlDown).Row
all = all & Trim(Sheets(1).Cells(i, 1).Value) & ";"
Next i
to_mail = Left(all, Len(all) - 1)
MsgBox to_mail
Set olApp = New Outlook.Application
Set
Dear Admin,
Can you please add me for the excelmacros mails, my email address is
gau...@omanairports.com.
Thanks & regards,
Gaurav Bansal
Muscat, Oman
--
--
Some important links for excel users:
1. Follow us on TWIT
I have created a complex spreadsheet that extracts certain worksheets
and modules and creates another workbook which is subsequently emailed
using Outlook to a list of individuals. It is not a complete copy of
the original workbook as there is information which must not be sent
out.
However I hav
Hi All,
I am new to this group. I did not know if I should create a new
Discussion or enter in one with the same kind of subject in under
discussion, thought I did tried the second.
I am trying to know if is it possible to create a VBA UDF that will
be multi thread in a multi core cpu, or if
I am trying to amend a VBA macro that I created some time ago using
WinXP and Excel 2003.
This macro sends a temp worksheet via outlook to the names listed in
the sendMail.array.
What I am now trying to do is create a dynamic named range somewhere
in the workbook that can be added to or email add
Hi Dave
Excellent work, I never thought that the conversion can be done by formula.
Regards
Rajesh Kainikkara
On 2/5/11, Dave Bonallack wrote:
>
> Hi Solomon,
> Have a look at the attached. Most numbers-to-text conversions are done with
> VBA, but this one is done with formulas and functions. It u
Thanks for your suggestion. Have given up and have now implemented
code to perfrom validation myself but really appreciate your response.
My first time using the forum and impressed with the support out
there , so thank you.
On Jan 31, 11:34 pm, clivey wrote:
> mmm...this rings a distant bell !
>
THANKS DEAR
VIKAS
On 2/4/11, rajan verma wrote:
> Hi
> I have created an attached Add-In for that..
> use Function =Inword(your_Digit) after install this..
>
> Note.. it will not show Amount after Decimal Point..
>
> Rajan
>
> On Thu, Feb 3, 2011 at 3:14 AM, solomon raju wrote:
>
>> Hi Al
Thank You Dave.
On Sat, Feb 5, 2011 at 12:41 PM, Dave Bonallack
wrote:
> Hi Solomon,
> Have a look at the attached. Most numbers-to-text conversions are done with
> VBA, but this one is done with formulas and functions. It uses a bunch of
> cells to do its workings. In your case I have put those
Hi Solomon,
Have a look at the attached. Most numbers-to-text conversions are done with
VBA, but this one is done with formulas and functions. It uses a bunch of cells
to do its workings. In your case I have put those cells in the range A50:K62.
If you need that range for something else, then y
14 matches
Mail list logo