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
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
On 2/16/11, Aindril De aind...@gmail.com 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
michael.lovel...@gmail.comwrote:
I am struggling with this and wondering if you could help..
Worksheet 1 Column A B
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
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
thanks alot its awesome
On Wed, Feb 16, 2011 at 8:48 PM, ashish koul koul.ash...@gmail.com 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
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,
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 stv.nels...@gmail.com 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
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
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
Thanks Ashish Sir,
For such nice solution time
Sorry for late reply
On Tue, Feb 8, 2011 at 8:23 PM, ashish koul koul.ash...@gmail.com wrote:
try this
On Mon, Feb 7, 2011 at 9:10 PM, maulik desai mauliksde...@gmail.comwrote:
Hello sir
please provide me the correction in your macro
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 koul.ash...@gmail.com wrote:
can you please send the sample workbook
On Thu, Feb 17, 2011 at
send a mail on excel-macros@googlegroups.com and attach the workbook
On Fri, Feb 18, 2011 at 5:43 AM, RFisher fishe...@uregina.ca 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
13 matches
Mail list logo