If I create an UDF and use Dim to create some variables do I have to
make sure by the end of the function these variables are set to =
Nothing
Here's an example:
Function FindRing(rng As Range) As String
Dim cell As Range
Dim strColumn As String
Dim intDelim As Integer
Dim intColC
I'm a beginner with VBA and looking for some guidance in how to
establish what I'm trying to do.
Column A Column B Column C Column D
1/15/2010 6/30/2009
3/2/2010 4/15/2008
I'm trying to create a VBA formula that will do the following in
columns C and D:
Column C should just be one yea
Thank you for the reply. While this works fine, it find it that it requires
a lot of copy and paste back and forth. I was looking for an answer that
would be more like creating a file in .txt format.
Some time ago I had a similar problem and the solution involve this code:
Filename = InputBox("
So do you suggest I un-install and re-install Office?
On 22 Oct, 15:20, Ashish Jain wrote:
> Hi Simon,
>
> Application.DisplayAlerts = False still works !
> It works in all versions of excels i.e.2003, 2007 & 2010.
>
> Take Care of these points:
> 1. Use new event macro - Private Sub Workbook_
Hi Omar,
Since the code is displaying in-built popups/windows, there is no "for
loop" required. However, sheets can be displayed using for loop but
here in this code, to select any sheet from workbook, it's not
required.
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified A
Hi Simon,
Application.DisplayAlerts = False still works !
It works in all versions of excels i.e.2003, 2007 & 2010.
Take Care of these points:
1. Use new event macro - Private Sub Workbook_Open()
2. Enable the Macros(Right below Formula Bar) whenever you open the
workbook.
Regards
Ashish
Enjoy
On Fri, Oct 22, 2010 at 6:26 PM, Gmail wrote:
> Yes the format for the date is yymmdd
> I am working with excel 97
>
> Sent from my Blackjack via AT&T
>
> On Oct 21, 2010, at 10:35 PM, Srinivasan Ethirajalu <
> srinivasan.ethiraj...@gmail.com> wrote:
>
> 1)
>
> PropertyID Account#
We recently upgraded to Excel 2007 from Excel 2000. I have a VB6 app
that uses Automation to start Excel, loop thru a lot of workbooks
opening each of them and then check various things in the workbook. It
worked fine in Excel 2000 and uses Application.Visible = False and
Application.DisplayAlerts
Yes the format for the date is yymmdd
I am working with excel 97
Sent from my Blackjack via AT&T
On Oct 21, 2010, at 10:35 PM, Srinivasan Ethirajalu
wrote:
> 1)
>
> PropertyID Account#Date Time Net Funded
> 1212178 2 10/10/2010 11:02481
> 1212178
Solution in the attachment.
Regards,
Ajay Varshney
On Fri, Oct 22, 2010 at 6:04 PM, ayoub Kakande wrote:
>
> Hello,
> Will greatly appreciate any help on this coz for over a week I have failed
> to get over it
> In need a formula to calculate the total best 8
>
> N.b
> 1) Total should be on
Hello,
Will greatly appreciate any help on this coz for over a week I have failed
to get over it
In need a formula to calculate the total best 8
N.b
1) Total should be only for those who attempted at least 8 subjects
2) If some one has more than 8 subjects I need only a sum for the best 8
subject
kill command is used for deleting a particular file from the system.
exp : Kill "location of the file"
location of the file should be in double inverted commas.
Regards,
Ajay Varshney
On Fri, Oct 22, 2010 at 5:39 PM, ghanshyam jaiswal wrote:
> Dear sir
>
> I am ghanshyam jaiswal ( your studen
Dear sir
I am ghanshyam jaiswal ( your student ) and once a time tell me a kill
function but i forget
pls. sir how to run kill function in macros and excel
regards
ghanshyam
9555693234
--
--
Some important links f
Sorry
I don't understand from which line the code get the list of sheets names?
There is no (for.. next) in code
Thank u very much
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Ashish Jain
Sent: Friday, October 22, 2010 10:34 A
Very Good Information!
On Fri, Oct 22, 2010 at 1:33 PM, Ashish Jain <26may.1...@gmail.com> wrote:
> Hi Omar
>
> Here is line by line description of the VBA code you provided:
>
>
> Sub OMAR_QUERY()
> 'Error Handling ON: In case of error, it will skip to next line.
>On Error Resume Next
>'
2010/10/22 Ashish Jain ashishj...@openexcel.com
>
> 3. In cell A10, use the formula below(any version of excel):
> =If(A9<=0.5,2,If(A9<=0.8,3,If(A9>=0.8,4,3)))
>
an alternative to the formula of Ashish Jain for point 3.
=MAX(FREQUENCY(A9,{0.5;0.8})*{2;3;4})
regards
r
--
---
Thanks for the info Ashish. After much searching on the Internet I
was begining to suspect that this was the case
It looks as if I will have to resort to manually exporting the forms
and modules to text files, ready for my routines to pick up
--
-
Hi Dean,
Here is the solution:
1. & 2. Just use this formula
Excel 2007 or Excel 2010
=IFERROR((I55/I54)*3600," ")
Excel 2003 or older
=IF(ISERROR((I55/I54))," ",(I55/I54)*3600)
3. In cell A10, use the formula below(any version of excel):
=If(A9<=0.5,2,If(A9<=0.8,3,If(A9>=0.8,4,3)))
4. Watch a
if you want to work with csv files closed, please open the csv file with
Notepad, copy and paste the contents here.
regards
r
2010/10/21 CAN
> I have a .CSV file see sample below which I need macro to convert
> to .txt file in an specific format.
>
> Orginal file will be like this.
>
> Propert
Hi group.
I am very inexperienced in using MS Excel however I am trying to
develop a simple spreadsheet which will do a calculation that I have
to do on a regular basis. I have several questions which I hope that
the people within this group can kindly help me with.
Ok, here goes.
1 - I want a c
Plz help me
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3.
Hi Chris
Due to the security reasons, this is not possible through VBA/VSTO.
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
On Oct 20, 7:06 pm, ChrisDixon w
Hi Chris
Due to the security reasons, this is not possible neither through VBA
nor VSTO.
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
On Oct 20, 7:06 pm,
Hi Hemant,
This group is to help MS Excel & Office applications users in their
day-to-day issues to raise their self-esteem with technology usage. We
encourage you to proceed with the first step and we'll help you rest :)
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Ap
Hi Omar
Here is line by line description of the VBA code you provided:
Sub OMAR_QUERY()
'Error Handling ON: In case of error, it will skip to next line.
On Error Resume Next
'Error handling used specifically for this line of code.
'If there are more than 16 worksheets, it will execut
The file was sent to you through mail.
For any thing you can mail me or Can catch me on google talk.
Regards,
Kishan Reddy, K
On Oct 22, 11:26 am, "Kishan Reddy, K"
wrote:
> I had gone through the excel file,
> I think, the format has to be changed, so as to enable stock splits
> and bonus issue
Best answer is =na( )
@anandydr: Very talented answer. GOOD LUCK
*
*
On Fri, Oct 22, 2010 at 12:02 PM, anandydr wrote:
> If we put =na( ) in the empty cell against May month the graph would
> become straight, otherwise the average of april and june month may be
> inserted there.
>
> On Oct 21,
If we put =na( ) in the empty cell against May month the graph would
become straight, otherwise the average of april and june month may be
inserted there.
On Oct 21, 6:03 pm, Danilo wrote:
> Instead of a blank cell, insert the average between the previous and
> the subsequent period.
> DV
>
> On
28 matches
Mail list logo
