send a mail on excel-macros@googlegroups.com and attach the workbook
On Fri, Feb 18, 2011 at 5:43 AM, RFisher wrote:
> Hi Ashish,
> Sorry I'm really new to google groups. How do I "send" the sample
> workbook? Can I post it here somewhere?
> Thanks and sorry to ask so many questions.
> Ryan
>
>
Hi Ashish,
Sorry I'm really new to google groups. How do I "send" the sample
workbook? Can I post it here somewhere?
Thanks and sorry to ask so many questions.
Ryan
On Feb 16, 8:19 pm, ashish koul wrote:
> can you please send the sample workbook
>
>
>
>
>
> On Thu, Feb 17, 2011 at 3:03 AM, RFis
Thanks Ashish Sir,
For such nice solution & time
Sorry for late reply
On Tue, Feb 8, 2011 at 8:23 PM, ashish koul wrote:
> try this
>
>
> On Mon, Feb 7, 2011 at 9:10 PM, maulik desai wrote:
>
>> Hello sir
>>
>> please provide me the correction in your macro actully i just want to
>> chang the
Thanks mahesh,
there is some problem with the code
when i click on Create workbook button it give me error in code
ActiveWorkbook.SaveAs (sPath & sFileName)
also border part also not execute
request u to kindly check the same
And my earlier mail have mentioned that each process has is own te
I think someone is using my name in vain - unless there are two Dave's in the
world - and I don't know how that could be...
Dave.
Date: Thu, 17 Feb 2011 09:15:24 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ Import .csv & match records
To: excel-macros@googlegroups.com
write
on error resume next
on the line above in the code which is giving errors see if that helps
On Thu, Feb 17, 2011 at 8:17 PM, RCGUA wrote:
> With Microsoft Excel 2003, using the "Web Query" feature, I record a
> macro, put the URL of the website into the New Web Query and that
> opens a
Piece of cake...
I can probably write it in 20 minutes.
=
Option Explicit
Dim Col_Array_Code1, Col_Array_Code2, Col_Array_YR, Col_Array_MM
Dim Col_Array_CoName, Col_Array_Dept, Col_Array_Qty, Col_Array_Amt
Dim Code1, Code2, YR,
thanks alot its awesome
On Wed, Feb 16, 2011 at 8:48 PM, ashish koul wrote:
> j1 start date
> j2 end date
>
> monday =I
> F(TEXT(J1,"")<>"Monday",NETWORKDAYS(J1,J2)/5,INT(NETWORKDAYS(J1,J2)/5)+1)
>
> saturday = INT(((J2-J1)-NETWORKDAYS(J1,J2))/2)
>
> On Wed, Feb 16, 2011 at 7:10 PM, Rajas
With Microsoft Excel 2003, using the "Web Query" feature, I record a
macro, put the URL of the website into the New Web Query and that
opens a new instance of Internet Explorer. Using the Web Query, I go
to a specific table within the tables on the web page and select the
table that I want to get
I am on Excel 2003,. I have a spreadsheet with 12 monthly tabs one
for
every month of the year January, February … December.. This file is
called montly_totals.xls and is located in P:\DAM\WI_FTP. There are
a
total of 200 accounts set up in each of these monthly tabs. Each of
these accounts start
On 2/16/11, Aindril De wrote:
> Hi Mike,
> Please use:
> =VLOOKUP(A2,Sheet1!B:B,1,0) instead.
>
> Regards,
> Andy
>
> On Wed, Feb 16, 2011 at 2:21 AM, MikeMikeMike
> wrote:
>
>> I am struggling with this and wondering if you could help..
>>
>> Worksheet 1 Column A & B
>> Keyword Category
>> teleco
Hi,
Sorry - didn't see your attachment.
Link your button to the following macro, which can just live in a module:
Sub refreshRange()
Range("B40:B54").Calculate
End Sub
Alternatively, you could do away with the button and have the macro fire
whenever you change B39. This macro would live in the V
Hi Aduh,
I assume that you have the Calculation set to Manual.
One way would be to use a selection change event that detects if the selected
cell has a formula in it, then calculates just that cell.
The following code goes into the VBA sheet window:
Private Sub Worksheet_SelectionChange(ByVal T
13 matches
Mail list logo
