I've tried unsuccessfully to stop userforms coming up in the following
code. What can I put in in the different places to stop the userforms
appearing (or the suerform appears and the clcik on the userform button
to happen automatically with screen application off.) Thanks.

Is there a way to pull a timestamp from an excel spreadsheet for whe
that spreadsheet was last saved?  
If not?  Is there a way to have excel update a timestamp cell PRIOR t
every time the spreadsheet gets saved?  

Hi people, im quite new to macros and theres a few things i need to do
which cant be done using the 'record new macro' function. So does
anyone know a code for:
1)'selecting the second to last sheet of all the worksheets'

Hi, please help...
I am trying to total up commission figures in a column that match a specific
year. Each row contains a cell for the date it was entered, the customer
details and commission earnt.

I have a macro which makes use of the solver add-in.
I want multiple users on multiple machines (which may have Excel installed
in various paths or drives!) to be able to use this.
I have used the line

I can't get my head around why this simple piece of code won't work in
release, but does in step-by-step debugging. This code is part of a
userform with two calendars on it.
Ideas anyone?

Hello. Does anyone know how to do this? For exemple i need to copy
several rows. If i try to do this i get an error. Thanks.

I realize with links in cells its simple to pull data from other
workbooks.  But what about with VBA?  Is it possible?
If so, how?
Furthermore, if so, will the links be relative as well or does vba

Col A has about 45,000 vertical cells containing data.  Each "block" of
related data (from "Name" thru "Amount") occupies either 5 or 6 cells.
Each "block" always contains the "Name", "Stock Number", "Street",
"City" and "Amount"; however, the "Age" may not always exist.  There

Im new to the world and headaches of excel VBA, just wondering what th
syntax is for multiple row selection in the row source property of
list box (for a form) ? any help would be greatly appreciated...
Even better, what I'm trying to acheive is effectivly text box filte

Is there simple macro to copy and insert existing row data and then move
down and repeat for all rows?
Example needed:
Rows existing

Hi
I want to make the lastrow of sheet1 column A common knowledge between
my macros. Reason being is i want to refer the the lastrow a lot of
times

I created an add-in to be used on several (10-15) networked computers.
My plan was to just put the .xla file on the server and have each local
machine link to that add-in.  That way, when I make changes, I don't
have to go copy them to everyone's local folders.  This has worked

If Worksheets("SJournal").Cells(t, "A") = Worksheets("Invoice").Cells(t,
"B") Then Worksheets("Invoice").Cells(t, "J") =
Worksheets("SJournal").Cells(t, "J")
If Worksheets("SJournal").Cells(t, "A") =

We created a macro using Excel 2000 and our computer have since been upgraded
to use Excel 2003, not the macro does not work properly when we try and open
it in 2003.
Is there a solution for this other than to rewrite the macro?