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
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
--~--~-~--~~~---~--~~
-
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...
--~--~-~--~~~---~--~~
--
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" wrote:
> Dave,
>
> Here is the worksheet, reworked as per your specification
>
> Workbook_Open event changed. Assumpti
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 wrote:
>
> Hi Gurus,
>
> I am Ramesh, new to vba programs. I need a macro to calculate sum for
> range of column. The should be
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
> T
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.
Thanks&Regards
Ra
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
'your
Jay, it defeats the purpose of using public forum if you sent
solutions to personal email. Post it here.
On May 29, 6:03 am, Jay wrote:
> I have sent your solution on your mail id.
>
> Pls check it.
>
> On May 29, 11:26 am, Prashanth Banneni wrote:
>
> > Hi All,
>
> > I have a issue with excel.
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
Sheets("sheet7
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
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 wrote:
> 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 2008-04 BIL.xls and
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 wrote:
> hi bala
>
Dear Satish,
Attached file is the solution of your question.
Regards,
Lavprasad
On Fri, May 29, 2009 at 2:47 PM, satish wrote:
> 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 conv
You can try Sumproduct
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Nidhesh Dhawan
Sent: 29 May 2009 02:28 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ SUMIF for multiple conditions
Hi,
Can any bo
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
if you are using excel 2007 then you can use SUMIFS.. or otherwise use
SUMPRODUCT
Regards,
Andy
On Fri, May 29, 2009 at 3:57 PM, Nidhesh Dhawan wrote:
> Hi,
>
> Can any body help me with applying sumif formulae with multiple conditions.
>
> I have following reservations:
>
> 1) Don't want to use
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 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 end dat
Hi
find the code below
Sub test()
Dim strAddress As String
strAddress = Range("B65536").End(xlUp).Address
Range("B3").Select
While ActiveCell.Address <> strAddress
If ActiveCell.Offset(0, 89).Value <> "Labor" Then
MsgBox "Cell " & ActiveCell.Offset(0, 89).Address & " is
empty"
I have sent your solution on your mail id.
Pls check it.
On May 29, 11:26 am, Prashanth Banneni 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 end date the range if date
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 ActiveSheet.QueryTabl
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.
N
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
--~--~-~--~~--
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 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 incl
25 matches
Mail list logo
