|
|
How to reference an active cell by
Tomá¹ Vognar
I've recorded a simple macro for Excel, where I work with a row. But I want
to work with a row the active cell is on, but Macro Recorder has writen me
an...
|
March 14th, 2008 08:56 PM
by JP[_5_] 
|
5 |
123 |
|
|
|
cell format by
chris
When I enter a whole number (i.e. - 1, 2) into a cell, the result is a
percentage (i.e. - .01, .02). I have reset the format to number, with no
success.
|
|
2 |
81 |
|
|
|
|
|
5 |
118 |
|
|
|
blank lines in text cells by
Ed Williams[_2_]
Still no answers, could someone PLEASE offer advice???
"Ed Williams" wrote:
Horizontal = General
Vertical = Bottom
?
"Kevin B" wrote:
|
|
1 |
81 |
|
|
|
no values by
kaja
hai i am having a values on the columns a and b in the column c i like
to have the total. i used sum function to make total it shows 0 always
whether there is...
|
|
1 |
81 |
|
|
|
Calculate Days between 2 dates by
MR.WJCA
Hiya,
I'm using the simple option =A1-A2 to calculate the days (in cell A3)
between 2 dates.
Now I want to do the same but if A2 is blank the cell A3 has to...
|
March 14th, 2008 08:27 AM
by Stefi
|
1 |
106 |
|
|
|
|
March 14th, 2008 04:27 AM
by Max
|
1 |
75 |
|
|
|
Splitting Data in a Cell into Groups by
Howard
I have a issue where I have a list of 3 letter codes seperated by a ; that I
need to grouped by the first letter of the code (ABC, ACB, AAA and BAA, BAB,
BAC...
|
March 14th, 2008 01:37 AM
by Howard
|
1 |
124 |
|
|
|
Headers and Footers - How to copy? by
The Hun
Using Excel 2002
When doing a copy/paste of a worksheet into another Excel file, or
into another tab within an Excel file, how do we make the header...
|
March 13th, 2008 11:00 PM
by Red
|
1 |
133 |
|
|
|
running balance by
PR Kid
How can I have the running balance show up as I plug in number without it
showing the balance down the entire colunm if I use =b2+c2+c1 as the formula
...
|
|
2 |
97 |
|
|
|
problem with macro by
gls858
I found some code that imports a text file to the open workbook on MSKB:
Sub ImportTextFile()
Dim DestBook As Workbook, SourceBook As Workbook
...
|
March 13th, 2008 06:42 PM
by gls858
|
0 |
74 |
|
|
|
wasy macro question by
gls858
I used the macro recorder to get the code to resize columns on a worksheet
Cells.Select
Range("A1766").Activate
Cells.EntireColumn.AutoFit
What I...
|
March 13th, 2008 06:19 PM
by gls858
|
6 |
71 |
|
|
|
Move data to another sheet by
tjvols
I am trying to move data from one worksheet to another moving only
lines with data. This is what I have
A B ...
|
March 13th, 2008 03:37 PM
by tjvols
|
0 |
79 |
|
|
|
Removig Duplicates by
dk
Is there anyway to remove duplicates when the first 3 words in cell are the
same even though the last few words are not the same
ex:
...
|
|
1 |
65 |
|
|
|
Margin Account by
Husky
I am looking for an excel spreadsheet that would help me caclualte the margin
call amount in an account. For example, if a client invests $10,000 and the...
|
March 13th, 2008 01:46 PM
by Husky
|
0 |
91 |
|
|
|
Dividing a linear goal by
TheNewGuy
I am trying to chart a weight loss goal and I want to put in a starting
weight and a goal weight in a sheet showing a wieght goal for each day and
have excel...
|
|
2 |
140 |
|
|
Help with a multi if then else formula. by
Pank
I have the following scenario for which I would require one formula which
would be in cell E25:-
A numerical weight amount is input in cell A25.
If the...
|
March 13th, 2008 10:31 AM
by Max
|
5 |
242 |
|
|
|
Hour format by
tafexpert
I'm trying to format cells in excel 2007 with the hh:mm format and keep
getting a date / time show in the function line and the wrong time in the
cell. e.g....
|
|
2 |
88 |
|
|
|
|
March 12th, 2008 09:11 PM
by LDS
|
4 |
70 |
|
|
|
Excel on Mac -- Where is formula bar? by
The Hun
My friend has a Mac is now learning Excel. She has toolbars Standard
and Formatting checked.
The formula bar is missing from up in the menu of the...
|
|
3 |
116 |
