I'm making a spreadsheet with names and addresses on "Sheet1".
This is in a particular format, and cannot be changed.  From this sheet
I want to put the names and address in a "label printing" format.  To do
this I need to grab the names and address off of the first sheet.  

I currently have this existing code that checks to if the value is the
same between col E and P and if true, the row is deleted.
'lastrow = Cells(Rows.Count, 4).End(xlUp).Row
'For i = lastrow To 1 Step -1

HI...
how can i use the combo box as a cell reference, so that when i choose
a text from the combo box, and save it....the text on the combo box
will saved on the cell specified...

hi,
can please send me the proper syntax for message box...my code doesn'
seem to work.
thans

I am still trying to get the Benford's law application to run.  The
application creates the variables for running the application.  The variables
are as follows:
Dim One, Two, Three, Four, Five, Six, Seven, Eight, Nine, Zero, firstone

I have a form that is like a calculator.  As it is called, the form has a
text box with a value = 0.  As the user types in his value, the "0" does not
disapear like a calculator would.  Is there a way to set the textbox to
clear it's content as the user enters his value.

Hello friends
I have a formula in each cell of column L and R.
Example
Formula in cell L6 is =IF(J6<>K6,0,1) & Formula in cell R6 is

Good afternoon,
I am working on developing something that has multiple modules and
subs...  Anyway, I am wondering if anyone can give me ideas on the most
effective way of dealing with errors if they occur while the program is

Here's what I have for a formuls for a cell: =ROUNDDOWN((C17/10),0)  I
want to take the answer for that (which happens to be 1051) and say
"limit the answer to 1000".  In other words, for that column, I want
the maximum answer returned to be 1000.  Can't be more than that, but

I'm working on a macro to open a series of files in the same directory,
copy the page, then paste each page into a corresponding sheet with a
corresponding name in a different workbook.
'Change to appropriate method and file

I need to have some worksheets reference each other.  It's probably easiest
to give a simplified example of what I'm trying to do:
WORKSHEET NAME: FRUIT
                    CELL B8 HAS VALUE "ORANGE"

If I have any global variable and/or constants to declare, and they are
limited to one module, which is the better method to declare them:
Option Explicit
Dim myString as String

Hello Friends
I am looking for a simple macro.
The value of cells in column M and J is linked to two checkboxs in each
row. When I check the first box, the value of cell in column M becomes

I have a workbook that contains a couple of different worksheets. One of the
worksheets represents a master data sheet. I have a user that updates that
sheet with project for the various groups within the company. All of the
projects go on this single sheet. Right now what the ...

This question is two part.  I have a workbook that I have set up 12 sections
within one sheet.  The worksheet is named "2006".  The sections are Jan -
Dec.  I have set up a section for each month and will use to balance my
checkbook instead of having to write each uncleared check ...