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:
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 tim.deros...@gmail.com wrote:
I am doing
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 abrash...@gmail.com wrote:
Hi Ankur, could u pls send me the VBA e-books to my
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,
On Tue, Feb 2, 2010 at 7:02 PM, Sri Jai jaisri1...@gmail.com 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
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
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 2003
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.
Thank
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 (default
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
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
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:
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
Code-Cash
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
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 Global range
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 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
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
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 auto.to...@gmail.com
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
19 matches
Mail list logo