How can i convert the macro below to Acivecell.Formula = ??? i.e get
the cell reference of the resulting cell.
Sub activece()
ActiveCell.Value = ActiveCell.Offset(0, -1).End(xlUp)

depending on what the user of my form chooses in a combo box, the shee
hides different ranges.
However I also want to hide the other combo boxes and form parts whic
is laying on top of this range. How can I do this

I have just noticed some odd behaviour while programming a userform in
Excel 2003 (SP2):
I have some option buttons that I set during the initialise event of
the form.  I tried setting the values to 'vbTrue' and I get the

I have a 1 collumn  which I have seperated in to ranges, of various lengths,
with 4 empty cells below each range I am trying to loop through and sum each
range on the 3rd cell below each range.
Thanks in Advance

Hi am trying to get rid of the little box that shows up when you view with
"Wrap Text" turned off.  My download contains thousands of them.
Previously I've found it easy with:
   Selection.Replace What:=Chr(10), Replacement:="", LookAt:=xlPart, _

When I manually Copy then Paste Special>Paste Formats only the formats
are pasted, not the values.
However, when I use the following code in a WorksheetChange Sub...
Cells(1,1).Copy

I'm using VFP (Foxpro) to call Excel
Everything works on my own laptop, but when I transfer to clients PC I get a
problem
When my code tries to call a specific Macro in Excel I get back

hello is there any way to search a worksheet (sheet 1) for cells whose font
colour is red, and then print the contents in another worksheet (sheet 2)?
eg cell a3 contains 3255 and its font  colour is red,  
cell a33 contains 444 and its font colour is red.

I've made two simple funtions, had no error messages. The functions are
restricted to the specific work sheet where they were made.
When I want to try them in a work sheet, they do not appear.  Usually this
sequence works: Insert/Function/User Defined. But it does not appear there ...

Hi there, can anyone tell me if its possible to sort by more than
columns.
I have 5 that i'd need to sort, but mmanually there is a limit of
columns.

I've a XML file (12.000 records , around 6MB) and it's schema (around 15
columns). I added XSD file as a map and mapped all columns from A1. When I
import the XML file, it takes around 5 minutes to complete on P4 2.6GHz 768MB
RAM notebook.

Our company has various offices, and i am trying to define which server
the user is on.
eg at login
thecompany.Edinburgh.tree

Could anyone help me understand what is wrong with this VBA line?
Target.Offset(0, 1).Formula =
"=VLOOKUP($C$1,CompConv,3,FALSE)*VLOOKUP(" + Target.Formula +
",CompConv,3,FALSE)"

I have a small VB project which works fine when launched by MSExcel, but
fails when launched by hyperlink from a webpage (IE5).  
The file booking.xls opens 4 other xls files and copies data from them, but
when launched from within IE, it opens the files OK but cannot then move

I have this column with names and titles:
This great person (bold) System Developer Specialist (not bold)
Can I devide this into two columns with the bold names and the titles not
bold in the other column.