Hi Dave,
Great name, by the way.
Have a look at the attached workbook and see if I have understood you
properly...
Regards - Dave.
Date: Wed, 27 May 2009 15:28:41 -0700
Subject: $$Excel-Macros$$ A Macro needed for the task beow
From: davidstev...@gmail.com
To:
follow the link https://sites.google.com/site/getexcel/-xla-files
then download password.xla addin.
Enjoy password free excel.
On May 19, 2:35 pm, Dhartikumar Sahu dhartiku...@gmail.com wrote:
hi group
can u suggest me how to remove open password in excel
Thanks
Dhartikumar
Hi All,
I have a issue with excel. Hope you can solve it easily :)
I have a list with start date and and end date.
Once i select the start date and end date the range if dates should be shown
in the Row 10.
Is it possible using formulae's because the file is too heavy and might
crash if we
Hi,
Can any body help me with applying sumif formulae with multiple conditions.
I have following reservations:
1) Don't want to use Array formulae.
2) Don't wat to use DSUM.
3) Dont want to apply concatenate.
Please send me an example if possible.
Thanks,
Nidhesh
Hey People
I need a small help, some of you might even find silly
I have big list of 12 to 16 digit Numbers e.g., 15145745854501. First i want
to convert all the number to 16 digit Number. e.g. if the number has only 12
digits i want to make it 16 digits by attaching 4 zeros at the starting.
Hi,
Please find the macro below.Modify column name as per your requirement
and also change the webpage link from the link given :
Sub TEST()
Dim CUSIP As String
Dim ISSUEDATE As String
Dim CUSIP_y As Long
Dim CUSIP_x As Byte
Dim ISSUEDATE_x As Byte
With
Hi;
use this formula and drag it == =IF($E$4+R9$I$4,$E$4+R9,)
Regards
Bala
On May 29, 11:26 am, Prashanth Banneni praba...@gmail.com wrote:
Hi All,
I have a issue with excel. Hope you can solve it easily :)
I have a list with start date and and end date.
Once i select the start date and
Hi Nidhesh,
I am attaching a sample file for you using sumproduct.
Here I have used two conditions:
Column A has the value of A
Column B has the value of DD
Add the values in Column C whenever both the conditions match
=SUMPRODUCTA1:A9)=A)*((B1:B9)=DD)),(C1:C9))
The same can be done
hi,
Sub test()
icount = Len(ThisWorkbook.Name)
icount = icount - 4
strtest = Left(ThisWorkbook.Name, icount)
ThisWorkbook.SaveAs (ThisWorkbook.Path \ strtest Format
(Date, dd-mmm-) .xls)
End Sub
with Regards
Bala
On May 27, 5:17 pm, Dhartikumar Sahu dhartiku...@gmail.com wrote:
hi
Dear group members,
I have got .xls file where two columns (F and J) must be parsed.
Columns look like this:
F J
aaa bbb
(empty) ccc
(empty) ddd
(empty) (empty)
fff ggg
(empty) rrr
(empty) vvv
(empty) (empty)
So, I need to go through these columns and copy data to other sheet:
column J - as
Guys,
trying to create a macro which will copy column A to column B. This is
simple
but only exception I m looking is macro should not copy any value = 0
I m trying this but no luck so far..any help will be greatly
appreciated..
Sub test_again()
If cell(a:a) 0 Then
Try the link below:
http://www.ozgrid.com/News/excel-validation-tips.htm
Norman
On Thu, May 28, 2009 at 12:09 PM, Ahmet Yalcin ahmetyalc...@gmail.comwrote:
Hello Paul,
Thank you. What I am trying is to gather data from same address on many
sheets in my workbook. The name of the file is
Hi Dear all,
Now comes to the tricky part :)
It is easy to use worksheet_change event to triger a macro when only
one cell in the sheet changes at a time. we can use
private worksheet_change(byval target as range )
If Target.address=$a$1 then
application.enableEvents=false
Hi Gurus,
I am Ramesh, new to vba programs. I need a macro to calculate sum for
range of column. The should be displayed with MsgBox.
For example: Column A has numbers 1,2,3,4,5,6,7,8,9,10...
I want to calculate the cells we entered and displayed on MsgBox.
ThanksRegards
Hi Vincent,
Try disabling the calculate thingy
Application.Calculation = xlManual
Look for change in $A$1
Application.Calculation = xlAutomatic
Regards - Dave.
Date: Fri, 29 May 2009 06:33:36 -0700
Subject: $$Excel-Macros$$ cells change triger macro problem
From: vincent2...@gmail.com
To:
WOW!! Thats fantastic, you are a champ. That exactly what I want. Now
How do I transfer the code to my workshhet?
thanks for all your work.
On May 29, 5:07 am, Ajit Navre aquas...@gmail.com wrote:
Dave,
Here is the worksheet, reworked as per your specification
Workbook_Open event
The attached workbook will display the sum of column A in a message box
whenever there is a change in column A.
Norman
On Fri, May 29, 2009 at 10:47 AM, Ramesh Katta kr.sap...@gmail.com wrote:
Hi Gurus,
I am Ramesh, new to vba programs. I need a macro to calculate sum for
range of column.
hi, i am looking for a macro code for a sheet named test (suppose),
when i open test it run a macro which will save a new file test1 and
add a column to test1 with code 22 in cell i1:i200 , is this can be
done?? please help me on this...
--~--~-~--~~~---~--~~
Hi All,
I am searching for macro that hide or delete column(s) if they haven't any
values, if any cell in that particular column(s) have any value then we
couldn't delete or hide the column.
Regards,
Shakeel
--~--~-~--~~~---~--~~
Ramesh - There are multiple ways to accomplish this. But since your
request is to just sum the numbers for the given column, here is the
snippet which is not production ready.
Dim oRange as Range
Dim iTotal as Double
iTotal = 0
For Each oRange In Application.Range (A1:A10)
iTotal = iTotal
20 matches
Mail list logo