Hi Guru,
How to use this code
pls explain full
Thanks In Advance
Nandkumar
On Tue, Feb 2, 2010 at 6:27 PM, Auto Tours Inv Limited wrote:
> Try this macro
>
> Sub PasswordBreaker()
>
>
> Dim i As Integer, j As Integer, k As Integer
> Dim l As Integer, m As Integer, n As Integer
> Dim i1 A
I forgot to say that YEARFRAC is from the Analysis ToolPak
Dave.
From: davebonall...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Help on excel formula
Date: Wed, 3 Feb 2010 13:01:33 +0800
Hi
I've used the YEARFRAC funtion and multiplied it by 12.
Have a look
Hi Paul,
I have been using the Standard module. The idea is to create an add-in.
The problem is that I have to use a particular range in different modules
and different procedures but i don't want to define them in each procedure.
Any idea ?
Thank you.
On Tue, Feb 2, 2010 at 10:59 PM, Paul Sc
Air code, not tested
Sub all_2010()
' Macro to searh & display PDf files
Dim i As Long
dim d1 as string
dim d2 as string
dim d3 as string
dim d4 as string
d1=inputbox("Select year, 1988-2010")
d2=inputbox("Select months, Jan-Dec")
d3=inputbox("Select A or B folder, default to both")
if d3="" then
Hi Ayush,
What do you mean by "outside the procedure'?
Dave.
> Date: Tue, 2 Feb 2010 08:24:36 -0800
> Subject: $$Excel-Macros$$ how to declare & define global range in vba
> From: jainayus...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hello Group,
>
> How can we declare and define Glo
I have the code listed below that searches a folder and if it finds
any PDF files its displays them with a hyperlink in the spreadsheet.
My
problem is that under the MAIN folder I have tons of files now and
its very hard to find the PDF I am looking for.
I redid my file structure under main and n
give this a shot.
Sub macrotrythis()
'insert and label the 4 new columns --- note: your sample has (4)
columns here which I presume normally are not?
Columns("E:E").Insert Shift:=xlToRight: Range("E1").Value = "Sec
Description"
Columns("E:E").Insert Shift:=xlToRight: Range("E1").Value = "Security
Hi,
I have the following problem, when I create some dropdown boxes via
VBA then all 99 ones have the some height and length in the excel
sheet. But when I save the file and open it again, then some of the
dropdown boxes are smaller or bigger then before. Has anybody a good
idea? Thank you
Code:
Hi Thanks for the reply.
The form i am editing / creating is part of Excel.. to get to it
TOOLS - MACRO - VISUAL BASIC EDITOR
I have some screen shots of the form running and also of the form in
VB Editor but cant find how to send these to this group to help
explain better ?
If this is possible co
I have a spreadsheet that contains a list. I need to evaluate all of
the cells in a particular column. I want the code to step through
each cell in the column and, if the color index of the cell is RED
(color index = 3), I want the code to stop so that I can look at the
spreadsheet and make a dec
What module are you putting the declaration in?
For instance, if you right-click on a sheet "tab" and select "View Code"
it opens up the VBA "Sheet Module".
You'll notice a module called "ThisWorkBook"
If you create "standard" Modules, there will be a "folder" called "Modules"
and a list of modules
Hello Group,
How can we declare and define Global range in vba , so that it can be
used across procedures & modules ?
Public rngNetLineAmt as range
Set rngNetLineAmt = Sheets("M-RAW").Range("AQ:AQ")
If i use above code outside the procedure..it does not work and throws
error.
Kindly advise.
T
Hi All,
i am trying to send my sheet in the body of the mail by ms outlook..
but i can't send it.. i was wrote a few codes and when i try it by
codes it is write an message in body " your browser don't support
that" it is telling my browser don't support that way..
my friends using office 200
Try this macro
Sub PasswordBreaker()
Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer
On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For
On Tue, Feb 2, 2010 at 7:02 PM, Sri Jai wrote:
> Dear All,
>
> Can somebody please help me on the below two scenarios
>
> 1) On the attached I would like to have columns E, F, G and H which is
> highlighted Yellow below when I run a Macro. These new columns must be
> automatically inserted
>
>
>
Hi Philip,
Please share an example with attachment. So that we can find a workaround on
it. I am a Data Analyst I did lots of projects on Database programming,
might be after looking your example I can provide a good solution of your
problem.
Thanks,
Deepak
On Mon, Feb 1, 2010 at 5:23 PM, Phili
hello friends, i had send my files to the moderator of group , you
will find them shortly in our file section
no need to post request here , just mail me on my id ankurpande...@gmail.com
On 01/02/2010, asha abraham wrote:
> Hi Ankur, could u pls send me the VBA e-books to my id...
> thanks in a
Hey Group,
Hope all doing well,
can any one help me in calculating Weighted mean for the attached file
Thanks
HemanatH
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
One easy way to do it is to use the camera tool & named ranges. The basic
idea is contained in the link below. You'd just swap out the traffic lights
for your own icons.
http://www.exceluser.com/solutions/traffic.htm
On Mon, Feb 1, 2010 at 12:50 PM, TD wrote:
> I am doing analysis of 8 possib
Could you please attach an excel worksheet for the problem you are facing.
Regards,
C.G.Kumar
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Philip
Sent: 01/February/2010 5:26 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Ma
20 matches
Mail list logo
