I am reading a cell that was populated with NOW().  It contains a time
part I do not want.  There has got to be a trunc() function somewhere,
but I can't find it.  Was going to try WorksheetFunction.Date, but
it's not there?  (I thought that anything available for use on the

I have a cell that uses a combobox selector to input data (data
validation).  I'd like the active cell to move right after the
selection is made.  Is that possible?  I can setup the enter key to
advance this way or that, but I can't figure out how to setup a mouse

i have some fields from a browser window pasted into excel. the become
shapes when pasted into excel. i give the shapes names starting with box 1
to box ?, depending on what's been pasted into excel.
when one shape is selected, it shows the following the the formula bar:

hello all !! i have my big set of 200 open workboooks ...
they all run a macro of analysis evry 2 seconds..
the question is that..
when the excel window is active window..

MS XP Pro, MS Office 2007.
Can anyone assist with macro to find the first blank cell in a column and
then to make it the active (selected) cell so that data can be pasted to it
and the row in which it is placed.

Does anyone know how I can disable an activex toggle button (I am imagining
it going lightgrey or something like that and the use not being able to use
it) depending on the value of a specific cell?
Any help is greatly appreciated!

I need to have a couple of offices use an application.  The front end is
written in Excel with Userforms and VBA.  The back end is SQL Server.
One office is on site.  The other office is in another building.  I need to
create a DSN for that office that can see the data across the ...

My spreadsheet contains about 100 to 200 rows of data.
We will also add more rows of data over time.  If I wanted
to add a search feature which would display a subset of
rows that match a specific criteria, what is a good way to

Would anyone know of a way to shorten multiple sumifs.  This formula
is getting very long.
Sumif(A2,Sheet1!B2:B10,Sheet1!D2:D10)+Sumif(A2,Sheet1!B2:B10,Sheet1!
F2:F10)+Sumif(A2,Sheet1!B2:B10,Sheet1!G2:G10)etc.

I would appreciate help with a macro or function to accomplish the following:
I would like to enter values in a single "data entry" cell and have it
update  
the next consecutive empty cell in a cell range. For example, cell j29 is the

If I open an Excel file which someone is currently using, Excel
will display a caption in the title bar that says "read only".  Excel
is probably telling me that the file is read only because another
user currently is using the file.

There was a very nice piece of code written by Aaron Bush (Oorang on MrExcel)
in 2007 which disabled cut and copy execution in excel, forcing the copy to
copy only values but maintaining the ability to undo
(http://www.vbaexpress.com/kb/getarticle.php?kb_id=957). Unfortunately, ...

Hi, I have successfully written menu code that runs each time an .xla
opens along with Excel.  It works fine on my machines in both XL 2003
and XL 2007 (as expected under the Add-in menu).  However, on other
people's machines, and much to my chagrin, the menu does not appear in

I have a need to generate a spreadsheet (timesheets for recording time) that
will do the following:
1.  Create a worksheet in the spreadsheet that has as the date in the
worksheet the date from the previous worksheet plus one day (incremental adds

Do you ever have a worksheet with lots of columns of data, and you wish you
could autofit the row heights using only some of those columns?  Me too.  
Sometimes you have a cell that has a bunch of text in it, and it makes the
row height a lot bigger than you really want it to be ...