This has got to be easier than I am making it. I need (via VBA) to locate the
end of a column of numbers, go one below the numbers (a blank cell) and enter
a formula that will calculate the sum of the numbers above. Since the amount
of data changes, this is what I have so far:

The macro below looks for an entry in a column (Taken By) in each line
of a list in the sheet Official List. If there is something there, it
moves that record to the sheet Deleted List, then comes back and
deletes the original line. It's suppose to go down a line, and

I would like to write a function that would return the page number on which a
particular cell will print out.
This is for a table of contents & other cross references on a single
spreadsheet for which the print range is multiple pages.

This question is hard to explain so i will show you an example:
dim strng as string
Set find = CurrentDb.OpenRecordset("Name", dbOpenDynaset)
find.MoveFirst

I have filled four combo boxes with the worksheet names from the workbook.  I
want to copy a (different) range from each worksheet chosen and paste them
together into a different worksheet within the workbook.  I am having trouble
at the point where I am getting the results of ...

I have a calendar popup on my form which pops over several fields however one
field stays on top.
How do I force the field into the background when the calendar pops up?
thx

I have a calculating function in VBA which returns an amount and I have
problems regarding how to show the correct number of decimals.
If the returning value has no decimal, it should show no decimal.
If the returning value has 1 decimal, it should show 1 decimal.

When I use the workbooks.range.formular1c1 object in VBA, the formula's do
not calculate and instead show #NAME? as the value.  I can edit each cell and
then press ENTER to get the values to update, but is there a way to get the
values to show as soon as the code completes?

am trying to import data to Access. Exported excel file has following
layout
Account_1
Date,  Amount

I have 75 worksheets in my workbook. Each worksheet has 17 columns with
various numbers of rows ranging from 1 to 1200. There are data in some
rows and numbers in other rows. In column D there are 2 to 4 numbers in
each cell like so

I'm not looking for volumes of info on this one.  (Um, that doesn't mean I
wouldn't appreciate it, though!  LOL)  I just need a jump start so I can
figure out what to do to get started.
I have a workbook with about 50 sheets.  4 of the sheets get data, dumped

Data (numbers in this case) imported from an Access database are not
recognized in the Excel worksheet I have them directed to. I have set up a
basic summation formula to add the numbers that are imported from Access...
only after I retouch or re-key the imported numbers will ...

I need to have a dialogue box come up with a note to the user when certain
conditions apply. I know how to create a macro that will run when the
conditions apply, I just don't know how to create the dialogue box that will
appear. Thanks in advance.

Good Morning,
how can i display the zeros to the left of a number? by the way i want the
format of the field to be a number because i have a macro that validates the
value entered in the field is a number.

I have a spreadsheet with a flowchart (created using Textboxes).  I
have written some code that looks at the text content of the textbox
and performs actions based on the text.  The question is:
How do I get the Macro to identify the textbox object I have clicked?