Is there a solution to this problem? The final space in a String is
deleted when assigned to a field in an Object variable.
Dim obHead As Object
Dim strLet As String

Do you know if there is a way to select a specific cell (making it the active
cell) when the user hovers their mouse pointer over an action hotspot?
Thanks,
Scott

I have created a quote template that is all based in userforms, which I
created in XP SP2 with office 2003 SP3. Most users are able to use the
template, however a couple of users are experiencing problems. When they
click on "Enable Macros" at the Security Warning box before ...

I would like to be able to list all the sequences of numbers using six
criteria.
The easiest way to explain it would be to say there are six jars, with
each jar containing anything from 1 to 10 counters.

Needed  a function that finds the Workbook level names
that are in a specified sheet and have put something together, but have a
feeling that there is a better (less code) way to handle this:
Function GetSheetNamedRanges(oSheet As Worksheet) As Variant

How do I find the cell address the end of a list.  See list below.  How to
find cell A5.
A1    Jim
A2    John

Okay, I'm not a total illiterate when it comes to Excel, and have used it to
put together some basic spreadsheets for my business, but I started mucking
around with a results sheet for my triathlon club when I realised what I
really need to do is WAY beyond my meagre skills and ...

Is there anyway to easily make revision clouds around specific cells/
groups of cells in excel?
Thanks,
David

I’m having a sharing issue that I hope I can get some advice on. I’ve
got one workbook that’s shared between 4 or 5 computers; shared settings are
set to not keep a change history and auto-update every 5 minutes. Then I’ve
got about 20 non-shared Excel workbooks on other ...

Could someone please review my code and the thread below and give me some
options?  The thread is on the second or third page of this message baord
already, and I fear that it is getting ignored.
Hi:

I was using the following macro to change the number format of a highlighted
range.  
   Selection.NumberFormat = "#,##0"
In Excel 97 and 2000 it was working fine.  In Excel 2007 it is giving me the

I want to prevent a user from accidentally changing the data more than
once but keep in mind the worksheet is copied every day on to a new
tab with the current date on it (so it must be prevented only on that
worksheet).

I've tried, and failed, to successfully open a template as an xlt file
(rather than xls) so I'm trying a different method to achieve what I need.
My problem is this. Having opened a couple of files, I want to activate a
specific one. Based on template filename.xlt, the workbook ...

I just learned about the "Office Developer" described in the following MS
article:
http://support.microsoft.com/kb/306130/EN-US
1) How can I find out if it is installed on my machine?

I have a spreadsheet with birthdates listed in column H.  Is it possible to
have certain rows automatically deleted when they hit 40 years old (or older)?