what's the best way to have data entered in a form and have it span multiple
rows? i know i can set wordwrap on a textbox field, but is the best/only way.
i'll probably need to span 4 or 5 rows.
also, is entry into one textbox able to put text in every other row?

I try to get the vlookup results to a variable via a vba macro
however, the table of data is in book2 and my macro and active sheet is in
book1. Both books are on the same directory
I use excel2000 and windows xp and it does not work

Im new to the list and havent done any programming in a while, but am
working on a spreadsheet for a customer and need help with something i think
is relatively simple (I just can't get it)
I have data in a set of 11 rows, which could be of varying quantites.. but

I want to write a macro by whic I will mention the number of character
in one column then it should select only those number of characters fo
the entire row.
eg. if I mention number of characters as 6 for 'column a', (I wil

The we are having is that once we install our custom Excel application on
the clients setup it fails to run the .Net code. The application is an Excel
spreadsheet which calls a bin directory with .Net DLLs in it. It runs fine
under office 2003 professional complete install.

date filter error
the current sheet is following(format "yyyy-mm")
a column
mydt

I have a table in SQL Server 2005 Express, and I want to use it as a
multiple level dimension, with the following structure:
Id,    Name, Parent
It is a Tree, I will mix it with the fact table in a view, I want to use it

I have an upcoming project requiring that VBA objects be sorted.
I know that I can write the objects out to a Worksheet and then sort
the objects and re-read them.
But I'd prefer to keep everything in memory.

When freeze panes is employed  it leave a black line across the screen.
Is there a way to get rid of the "black line" with code?
Cheers
Pete

SENARIO
I have a simple booking form but i have three charging tariffs simpl
cacls tell me the cost based on the hours this is achived by manuall
inserting a refrence cost,

I have a procedure that randomizes data until certain criteria are met
Those criteria are user-driven, and if they enter in criteria that ar
too "tight" it could take a very long time for the randomization loop
to compelte (and it's possible that they will NEVER compelte if th

On my forms when you use return key in field it displays a square symbol on
worksheet and also prints - how do I hide this?
tia

I want to write a procedure/macro that will decide if n = 1 To 10000
Step 1 Cells(n, "?") .Value on Sheet 1 equal a Cell.Value on Sheet 2:
if TRUE then I want to copy the entire Sheet 1 Row onto consecutive
rows on sheet 2: then I want repeat the procedure  for other values on

Can anyone help me with this ...
On a worksheet the user can enter one of two values in cell A1. These are
defined by a named range. For each of the three potential values a named
range exists called the name of the value in A1. Cell B1 uses these names to

I receive emails with tab delimited data looking like this
9:46 ET AAA 100 BBBB CCC DDD [EEEEEEEE]
I'd like to grab this data directly from my email account and load into
Excel sheet.