|
|
|
Automatically closing slave workbook when main workbook is closed...
Tue, 9 Mar 2010 03:46:54 -0800 (PST)
Hi
Have two workbooks - lets call them workbook1 and workbook2 for ease.
Workbook 1 is the main document, however, some of data is drawn from
Workbook 2 which is currently mininmized by following code in VBA
Workbook1:
Private Sub Workbook_Open()
Workbooks.Open "Workbook2.xls"
ActiveWindow.WindowState = ...
|
VBA Syntax problem
Tue, 9 Mar 2010 09:47:23 -0000
I am trying to set up a macro which would only run if there is a value in
any of the three cells to the left of active cell. The following does not
seem to work and would appreciate any help in correcting this:
If ActiveCell.FormulaR1C1 = "(SUM(RC[-3]:RC[-1])<>0" Then
run macro code
End If
JP
...
|
Excel 2010 (beta)
Tue, 09 Mar 2010 08:27:31 +0000
I am running Excel 2010 beta and have managed to install the Data Mining
pack. However it needs to be connected to the localhost to work.
Not being into networking, I find this aspect of things quite daunting.
Clicking on the data mining tap shows that I have no connection on the
'connection' icon.
Cli ...
|
Help!! urgent
Mon, 8 Mar 2010 19:21:01 -0800
I was using Excel 2007 quite happily, and must have hit something on the
keyboard, because now every time I touch keys windows spring open and I am
powerless to do anything on my spreadsheet. I have tried restarting the
computer. How do i turn off this feature? ...
|
putting a set of values into a group of bins
Mon, 08 Mar 2010 20:01:25 -0500
I have a column of numbers and I want to count how many are between 1 and 10, 11
and 20, 21 and 30, etc. I have been unable to develop any expression for the
COUNTIF function or a pivot table that works. Is one of those the way to go, or
is there another alternative.
Thanks
Elliott ...
|
show with messaje box when it's time and date
Mon, 8 Mar 2010 18:12:07 -0430
HELLO FRIENDS NEED HELP
I HAVE THE COLUMN (A) The time to write date and hour Next notice /Alarm, I
need
Warn me when it's time and date of notice/alarm start up show with messaje
box
Message with the message that I write in the same row of column ( B) in the
same row
EXAMPLE:
A ...
|
External Data wont refresh on a prtected and shared workbook...
Mon, 8 Mar 2010 12:28:01 -0800
I have a workbook that is used by multiple people over a network. In this
workbook I added some data from a site that i wanted refreshed everytime the
workbook is opened. I found out i can't protect the worksheet or protect and
share the workbook and still have it refresh the data. Is there a way to
prote ...
|
|
|
Replace massively formulas with new formulas
Mon, 8 Mar 2010 06:33:57 -0800 (PST)
Hi there,
would like to get your input/hints on how to solve the following:
In a series of cells in a row, I already have a formula calculating a
division among two other columns.
The rows are many (more than 500).
But now I need to apply a ROUND formula, on top of the existing ones.
ex. cell C5 = A1/B1
and I ...
|
How to replace ~ with other value ?
Sun, 7 Mar 2010 23:34:34 -0800 (PST)
Hi Reader
I have some cell have ~ in order number column, How to replace ~ to
two -- ?
Due vlookup can not handle ~.
Moonhkt ...
|
Print Dialogue Box
Sun, 7 Mar 2010 21:20:48 -0800 (PST)
What is the macro command (code) to just open the Print dialogue box
without printing?
I tried this macro ExecuteExcel4Macro
"PRINT(2,1,1,1,,,,,,,,2,,,TRUE,,FALSE)" but it printed the worksheet.
Than kyou. ...
|
|
|
