How does one stop the execution of the code?

dim cnum1,cnum0
cnum1 = 6
cnum0 = 3
cells(2,3).formula = "=vlookup(A2,sheet1!C:F,cnum1 - cnum0 + 1,0)"

I would like to know if a range contains any blank cells.  Is there a
shorter method than the one below that simply finds the first occurrence of
an empty cell?  Thanks.
Blank = "No"

I am devising a spreadsheet to log the progress on a list of clients,
through a set series of procedures. The idea is that each time a certain
stage has been passed, the corresponding date is entered in the relevant
column, at that client's row.

    I'd like to construct a macro that can generate the proper
volume number and number for a publication. Ideally, the user would
enter the year in a cell and run a macro that would generate the
year's volume/number on another worksheet.

This is just driving me CRAZY!!!
I have a worksheet which I have 20 forms created on that are
automatically filled out via another data entry worksheet. I have
edited them so that they have page breaks. So basically if anyone hits

I am dumping the values in an array using the Debug.Print statment as follows:
Debug.Print HourData(Counter - 1, 0) & " " & HourData(Counter - 1, 1) & " "
& HourData(Counter - 1, 2) & " " & HourData(Counter - 1, 3) & " " &
HourData(Counter - 1, 4)

Hi all,
I have attached a spread sheet with this problem. I desperately need
you guys help to solve this problem. The report attached here gives the
daily update of the invoices. Column 2 (Process), 5(Status) and 13(Item

We've developed a scripted reporting solution that uses the Excel COM object
for the reports creation.  Now we've got a customer asking about using the
system to generate web based reports, which we think we can manage as well
by converting the application to a web service.

Hi, I'm having problems with auto numbers, i don't know if is possible to do
that. I want to do a function that checks the points in column B and the
biggest point is 1st. For example, i have in column A the RESULTS, Column B
POINTS. in line 1 column B i have 50 points, and line2 ...

I have a user form that presents the user with a list box and a 'run'
button.
when this button is pressed I want to display another user form,
resized to show only the title-bar.

Is  there a way in which I can auto-size a userform to fit the whole
screen , dependent on moniter size.
regards
John

I have a 50 replies from a questionaire.. they have all filled in with
the number 1 for their choice. (all the workbooks is in the same
folder)
I'm trying to use an empty template of this questionaire, and have a

Hi all,
I have a simple query. I have created a macro. It needs a control key
to run. To put it more simple, it is a macro created manually and not
using the VB. Now, everytime I open the spreadsheet, I do not want the

Is it possible to set the row height using VBA code and not
Format>>Row>>Height?
Thanks all.