Hello, does anyone know how to add subtotals once my code has run a
sum for both the Par Value and a sumproduct for the coupon rate?
I have a code that gathers the data i need but i can't figure out this
last part.
https://www.box.net/shared/0fknh9819pk9t8m7jxz9
Here is the file i'm trying to
Software
dguille...@gmail.com
-Original Message-
From: Monizri
Sent: Friday, February 10, 2012 8:15 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Insert a row and subtotal
Hello, does anyone know how to add subtotals once my code has run a
sum for both the Par Value
at 10:55 PM, Monizri moni...@gmail.com wrote:
Hi, I have the following code that searches for data based on what i
type in it (in this case it is FHCX) and posts it in a new sheet.
How can i get excel to read a menu with selections using X in a cell
and feed it into the code below to produce
that instead of using a loop you would use FIND (look in vba help)
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Monizri
Sent: Saturday, October 08, 2011 9:01 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Read a menu and produce
gmail inbox, and reply to the mail.
OR
Go to box.net, and you can upload your file there, and provide a link here.
Regards,
Sam
On Sun, Oct 9, 2011 at 12:57 AM, Monizri moni...@gmail.com wrote:
Thanks Don, I can try FIND instead of looping, i am trying to add my
file but i don't
in activesheet.usedrange.specialcells(xlce
For Each c In Range(b2:b21,f2:f21,j2,j21)
If UCase(c) = X Then
'MsgBox c.Row
End If
Next c
End Sub
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Monizri
Sent: Saturday, October 08, 2011 2:56 PM
To: MS
Worksheets(Selections).Cells(1)
Application.ScreenUpdating = True
Set rngCell = Nothing
End Sub
On Sun, Oct 9, 2011 at 2:19 AM, Monizri moni...@gmail.com wrote:
The autofilter can be an alternative. Is it possible get the loop to
read into the second bit of code where it has FHCX
Hi, I have the following code that searches for data based on what i
type in it (in this case it is FHCX) and posts it in a new sheet.
How can i get excel to read a menu with selections using X in a cell
and feed it into the code below to produce results on a new tab?
Sub ServiceReport()
'