|
|
Help with code please by
Greg
How do I change the code below to look this range up on a sheet called "
Title "
Private Sub UserForm_Initialize()
UserForm1.Caption = Range("A1")
End...
|
April 7th, 2005 10:03 AM
by Greg
|
1 |
102 |
|
|
|
April 7th, 2005 03:43 AM
by Chance
|
3 |
141 |
|
|
Validating a Number ID by
Ruan
Hello,
I am struggling to write a formula to validate an ID Number.
Here are the valid options -
1) All numeric 10 character ID (example: 1234567890)
2)...
|
April 7th, 2005 02:36 AM
by Biff
|
7 |
151 |
|
|
Counting empty cells within a range of cells by
Rosehill - ExcelForums.com
A sheet can have a variable range of adjacent cells each containing
the value =1
The range defines the perimeter of, or surrounds a group of empty
cells...
|
|
0 |
400 |
|
|
Subtract several rows from a total by
LMB
Hi Guys,
I have a total in cell C32. I want to subtract numbers in cells C 34-40 and have the answer in cell C41. I know that =C32-C34 will give me an...
|
April 6th, 2005 10:33 PM
by CLR
|
5 |
132 |
|
|
|
April 6th, 2005 07:40 PM
by gls858
|
1 |
161 |
|
|
Problem setting up formulas by
David McRitchie
Hi Just Judy,
Bit hard to read your layout when columns don't line up
row1 reserved for column label headings:
c2: 500
A3: 2005-04-01 (a date)
B3: 10...
|
|
0 |
121 |
|
|
|
April 6th, 2005 06:49 PM
by Sharon
|
9 |
352 |
|
|
|
April 6th, 2005 05:25 PM
by ndevils
|
0 |
236 |
|
|
Need help with a formula by
Buckwheat
I am trying to get Excel to make some calculations for me. This is my first
time trying to use Excel and I can't seem to figure out how to tell it what I
want...
|
April 6th, 2005 05:06 PM
by eggman
|
3 |
102 |
|
|
Private sub by
Mark
I have the following running under a command button.
it works once and then the next time an error appears on
the following line under Sh
For Each Sh In...
|
April 6th, 2005 03:36 PM
by mark
|
3 |
90 |
|
|
HELP - Running Macros in VBA by
Louise
Why (&%¤#"!!!) are my macros in VBA not running? I have copied small Macros
from reliable sources on the Internet to Modules in Excel, but I can't make
them...
|
|
7 |
127 |
|
|
Sub BUandSave2() by
Mark
how can i adapt the following macro to run when you exit
the workbook instead of when i save.
Sub BUandSave2()
Application.DisplayAlerts =...
|
April 6th, 2005 12:13 PM
by mark
|
2 |
117 |
|
|
|
April 6th, 2005 06:24 AM
by Ruan
|
3 |
280 |
|
|
Sorting and displaying different results by
Mac
I have a spreadsheet made up of 2 columns - Drawing Number
and Drawing Name. I would like to have 2 different sorted
results show up on one page without...
|
April 6th, 2005 03:10 AM
by Max
|
1 |
80 |
|
|
|
|
1 |
181 |
|
|
|
|
1 |
107 |
|
|
NUMBERING OF A COLUMN by
D
I would like to use automatic number ascention in my 1st column, actually,
each row would ascend in number by 1
|
April 5th, 2005 05:13 PM
by D
|
5 |
119 |
|
|
backup by
Mark
when i save my budget report workbook, can i also save my
backup copy held in a diffrrent drive.
thanks
mark
|
April 5th, 2005 04:24 PM
by mark
|
4 |
155 |
|
|
|
|
4 |
122 |