|
|
Hiding Macros by
mrbalaje
I am using Macros in my excel sheets. I have protected my macro coding by
locking it, so that no one can able to see my macro coding.
But I want to protect...
|
|
2 |
75 |
|
|
|
|
2 |
366 |
|
|
|
April 18th, 2005 09:29 AM
by Max
|
3 |
133 |
|
|
|
|
2 |
213 |
|
|
Date through Macros by
mrbalaje
I am using macros in my excel sheets. Can anyone tell me how i can assign the
current date using macros.
( 1 2)
|
|
11 |
162 |
|
|
Brush up Array Operation by example by
frtklau
Dear all,
I found some examples of using Array operation like
IF(ISNA(MATCH(...
SUMPRODUCT(--(--A1:A100=5))
more advanced of VLOOKUP & Match.
to get...
|
April 18th, 2005 11:46 AM
by frtklau
|
5 |
147 |
|
|
MY SPREADSHEET IS NOT FILTERING CORRECTLY by
leighanne
I am trying so filter a selected persons data, to get a correct cost for this
person but at the bottom of the page it is also bringing up different...
|
|
1 |
94 |
|
|
|
|
6 |
126 |
|
|
Row Height by
Dennis B.
In a cell with row height set at auto-fit, I get an ######### error message
after exceeding a row height of 100 pixels. The problem is not solved even
if I...
|
|
2 |
75 |
|
|
Macro help by
nc
Hi
I have written a macro below to go through a list, copy each item in the
list, open a template and paste the item on the template, close & save with
the...
|
|
3 |
87 |
|
|
Row Autofit on Merged Cells by
Jluo
There is a cell in a row. The cell is merged with Columns C, D, E. When
I apply Autofit to the whole row, some of the content in the merged cell
is...
|
|
1 |
160 |
|
|
transposing values top to bottom by
Ted Metro
I know how to use the paste special transpose to move values, but need help
on this.
let's say I have these values in column A, starting at...
|
April 18th, 2005 03:10 PM
by galimi
|
3 |
80 |
|
|
|
|
1 |
174 |
|
|
Printing on one page by
jomedwards
I'm trying to print a holiday chart onto one page, this chart was done
manually rather than using the 'chart' option. I have fiddled around with the
wide and...
|
April 18th, 2005 04:04 PM
by bj
|
1 |
111 |
|
|
|
April 18th, 2005 04:04 PM
by Franz
|
3 |
91 |
|
|
pop-up files name menu by
Nader Farhadi
Hello,
I need help with setting up a macro that reads in different file names.
Each file contains 4 columns of data that I would like to be imported in...
|
April 18th, 2005 04:27 PM
by tina
|
1 |
73 |
|
|
|
April 18th, 2005 04:42 PM
by JulieD
|
1 |
120 |
|
|
HTML Help not closing the file by
pod
I am using HTML Help to display help information within my Excel program.
After I close HTML Help, the file system thinks that the .chm file is still
being...
|
April 18th, 2005 04:45 PM
by pod
|
0 |
81 |
|
|
Alphabetizing a list in Excel by
chamaman
I am making a list of all my DVD's, Cd's and etc. I want to be able to
type in the following information in a non Alphabetized order and have
Excel...
|
|
3 |
89 |
|
|
Merging info from a table to a report by
Gail M.
I have a large table of names, dates and financial
calculations that I need to 'regularly' put into a form.
The information changes each time. Right now the...
|
April 18th, 2005 05:24 PM
by Gail M.
|
0 |
86 |