Need Help with a Formula
Fri, 05 Mar 2010 15:04:49 -0800
I need some help: In this example I have a column of 5 cells B1:B5. I
also have another cell C1. I would like to have cell C1 to display the
most recent entry in the B Column.
Start
B1=Null C1=Null
B2=Null
B3=Null
B4=Null
B5=Null
First Entry
B1=4 C1=4
B2=Null
B3=Null
B4 ...
|
Printing to Day-Timer pages from Excel 2003
Fri, 5 Mar 2010 14:24:32 -0800
I have old printouts that indicate that in the past I printed from an older
version of Excel to 3.75"x6.75" pages, but I don't see any way to do that
using Excel 2003. How do I do that from Excel 2003? ...
|
validation for decimals
Fri, 05 Mar 2010 16:23:31 -0500
Hi there.
I need to set a series of cells so that the user cannot enter anything
other than 2 decimal currency values. Here's my code for this:
.Range("K" & sI & ":K" & sI).Validation.Add Type:=xlValidateDecimal,
AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:="0.00",
Formula2:="999999999.99"
...
|
Excel 2007 Ribbon - Remove unwanted custom toolbars
Fri, 5 Mar 2010 11:35:01 -0800
We had a series of engineering worksheets created in earlier versions of
Excel that utilized custom toolbars created solely for the worksheets. they
would be attached to the files which is how they were distributed to guys out
in the field.
Now that we are in the Office 2007 realm, our custom toolbars have be ...
|
Title Capitalization
Fri, 5 Mar 2010 10:15:25 -0500
Is there anyway to for a column to use Title Capitalization?
--
...
|
Printing Multiple Sheets
Fri, 5 Mar 2010 04:59:01 -0800
I know that I've done this in the past without any problems, but I'm using a
new (to me) computer running Excel 2003, and am having trouble printing
multiple sheets at the same time. I'm trying to select 2-3 tabs and printing
them all as a group. The advantage is that page numbers in the footer
reflect t ...
|
File won't Calculate
Fri, 5 Mar 2010 04:44:01 -0800
I have a 35MB file that locks up when calculating. It's a process that has
been use for several years; each year I do a "save as" to create the current
year's evrsion. By year end, it can grow to ~65MB. I never had a calc problem
before and it has worked fine all this year up to now.
Any ideas?
Thank you ...
|
|
|
Macros behave differnet when invoked by different methods
Fri, 5 Mar 2010 04:31:42 -0800 (PST)
Using XL 2003, i have recorded several macros. For example, i recorded
one that changes the "Move selection after Enter", to toggle the
selection either Up or Right. I created an icon, using the letter "Z"
to invoke it. When I click on the icon, the press Enter, the selection
will move as required. But, if i use ...
|
Permanently setting the default comment font in Excel
Fri, 05 Mar 2010 07:22:30 +0200
{Using Office XP under Vista Home}
How do I permanently set the default comment font in Excel? I want it
to be Time New Roman 12.
I've been through the Desktop > Appearance > Windows Classic > ToolTip
thing (changed it to Times New Roman 12) and even found and used a
macro that will change all existing comm ...
|
Excel 2007 Macro/VB Question DDE Question
Thu, 04 Mar 2010 15:16:56 -0800
I have figured out how to make a macro copy and paste the value to the cell in the next column and then go to the next row in the column. However, I cannot figure out how to create a macro that would enter a cell, hit F2, ?press enter? then proceed to the cell below it. The macros I create just paste the value fr ...
|
