I have a user form that loads at the beginning of a long list of vb
code as a splashscreen (Modal = 0), screen updating, events, and
autocalculations are all off.  At certain points during the code,
check boxes are updated with the status of the code.  When I step

I have the following formula:
=SUMPRODUCT((A8:A100<>"")/COUNTIF(A8:A100,A8:A100&""))
This formula counts the number of unique records in a column (A)
The column (A) grows every day to a variable amount I need to replace the

I have two columns of data- I would like to count the number of
entries in col B based on col A, put the cell value for col b and its
count result in col E and F, respectively. For example, based on the
cell values of "ACA1196" in col A, the values "A320" and "A333" would

From A100 to A200, I need to insert rows , but I do not want to push other
rows below A200 down. I know code can do it, but is there a hack here?
Clara
thank you so much for your help

I'm trying to catch the {Escape} key and not allow it to put up an
error when my form is open.  I have one of my command buttons set to
cancel true already, but it doesn't always catch the key press.  I've
found some mention of using this

We post questions and you answer them.
The essence of posting questions is to be concise.
Should we therefore waste your time by posting a 'Thank you'?
I am not sure what is the netiquette in this case.

I am creating a macro that ends by saving the current file into a
directory specified by the user.
The user specifies the directory name thru the following command:
fldr = InputBox("Enter the 3 digit folder name")

I am getting inconsistent behaviour on data between recording and running a
macro.
If I record a macro that selects all data, then sorts by an ID number (in
column A) and a date (in column B), I get asked the question about whether

We export data in Office HTML format, so that end-users may use it directly
with Excel.
According to the Office HTML official documentation (ofhtml9.chm), we use
&L, &C, etc. metadata within the text values of the headers and footers

I have 10 files (1 per person- S:\data\(initials)) they have the same format
(1st four columns) with data in them with the first row as a header.  I wish
to create 1 file for all this data, is there an easy way to obtain the data
from all the files and create a new one under S ...

I want to be able to run a macro which will delete the row selected if column
A is blank.  If it is not blank then message box "Unable to delete this row!"
I've looked through code already available but can't find anything that does
this.

i need to creat an excel that prevent the user to save the file unless
he enters data on certain cells, for example
if the user enters data on cell E10 he must also enter data on cell
F10, if he doesnt do that he cant save the file and a msgbox appears

I have created a Feild Purchase Order for my Company. (Blank P.O.)  I need
the numbers to jive with my acounting software that will not let me print
blank p.o's.  I would like to create a macro that will generate a new number
for each page printed so I dont have to worry about ...

I have created 9 checkboxes in a particular sheet in a single row,
each in a single cell.
first checkbox is named 'All' and other 8 are named 'A' to 'H'. I want
when I will check 'All' checkbox all the other 8 checkboxes should

Below is a portion of my code that I am trying to use to Mail a Report
If a certain value is in Report K6. I have introduced a Message Box
with Yes/No and my code is not mailing, but has not error messages.
The scenario in my example below is: If the City shown is London a