Thank you!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of GoldenLance
Sent: Monday, June 13, 2011 7:14 AM
To: excel-macros@googlegroups.com
Subject: Re: RE: $$Excel-Macros$$ Please help to make my project good.
=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999)
I am trying to populate a list box with the results of a query. I have
created the following code, which only populates the first column of a two
column listbox. The items in MyArray are present for both bolumns.
Dim MyArray()
ReDim MyArray(mycount, 1)
usrGLDist.lstOutput.ColumnCount = 2
For
H,
I tried the code and got a VB run-time error.
Run-time error '424';
Object required
There error highlights the yellow line below.
Here is the code as I have it installed.
' TEST Macro
' Macro recorded 6/10/2011 by Don Flak
'
'
Dim ie As Object
Set ie = CreateObject("Internetexp
=SUM(OFFSET(A5,0,0,MATCH(MAX(A$5:A$999),A$5:A$999,1),1)), copy this to A2,
and then copy across to other cells
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://t
Dear Excel Expert and Ashish,
pls look into the above excel file
If I am changing the % value in Q1,Q2,Q3, Jan & Feb & Mar
then total changes in B16 but I want the total to be as in b3 for that I
have to < or > the % value in d2
--
-
STDEV(i),
Excellent! Works like a charm. If I would like to add a formula to the
total column, that would only pick up only the Order Qty amount, how would I
do that? (the order number is a six digit number and adds to the total) I
would use =SUMIF(A$25:Z$25,"Order Qty",A26:Z26) after the fact,
Hi all,
I have some Excel sheets that I want to save as a UTF8 file in .txt
and .csv formats, using a VBA macro. I've found the following code:
'Function saves cText in file, and returns 1 if successful, 0 if not
Public Function writeOut(cText As String, file As String) As Integer
On Error GoT
dear excel guru,
thanks for the reply and sorry for late reply.
the macro only searches excel files containing the specified word but
not pdf or doc file.I do need the same for pdf and doc file.
thanks in advance.
On 08/06/2011, ashish koul wrote:
> try this
>
> rename sheet to rename files
>
yeah.. it is possible..
On Mon, Jun 13, 2011 at 1:05 PM, Manish wrote:
> Hello EE,
>
> Pls suggest.
> Is it not possible ??
> If its possible, I am ready to pay to devlop this module for me.. :)
>
> awaiting for your reply..
>
> Regds,
> Manish Pansari
> +91 9810 88 8281
>
> On Jun 10, 4:28 pm,
Hello EE,
Pls suggest.
Is it not possible ??
If its possible, I am ready to pay to devlop this module for me.. :)
awaiting for your reply..
Regds,
Manish Pansari
+91 9810 88 8281
On Jun 10, 4:28 pm, Manish wrote:
> Dear Team Member,
>
> Thanks for all of your support and assistant in excel, co
10 matches
Mail list logo
