I am still having problems with my varaibles. Below is the code i have
written, can anybody offer any help as to why it is not working?
Dim BottomRow As Range
Set BottomRow = ActiveCell

The below code places valuies from the Sheet-"Data" into the Sheet-"Job card",
BUT, the Highlighted LINE value DOES NOT apear, WHY ??
Removing the 'On Error Resume Next' i get a  Object Variable not set error.
Private Sub CommandButton1_Click()

In Microsoft Money and Quicken, you have the ability to change the date up or
down by using the "+" and "-" keys.  Does anyone know of a way to do that in
Excel?  For instance, suppose you had a column of dates.  I'm looking for a
way to arrow down this column and adjust each ...

I am new to VB programming  I am used to writing functions in other languages
like Perl...   ususally the last line or a return $A statement defines what is
returned by the function.  The few vba functions I have seen confuse me as I
have no indicator of what the function will ...

Excel XP, Win XP
The code below is an abbreviation of my code just to illustrate my problem.
The code simply opens the "One.xls" file, copies from "One.xls" and
PasteSpecial xlPasteValues to file "Two.xls",

I've just written a complex VBA-enabled project that gets sent out to
60+ people via a background call to Lotus Notes.  It invites them to
fill in information on the spreadsheet, then submit it back to me via
a spreadsheet button and another background call to Notes.

This code is supposed toset a conditional format to "hide" the contents of a
cell if the following line has the same date:
Sub test()
Dim strRange As String

I have tried written the following code, however it's incorrect and I
can't seem to work out how to correct it. Could anybody offer any help
please?
Sub test()

I have simple VB that prints all sheets in my workbook - see below.
Problem is that the order that it prints the sheets is not the way they
are visible - For example it prints Appendix G before Appendix A, yet A
is visible before G.  To complicate Matters there are hidden sheets

I'm trying to convert or to find a way to get the column letter from
its column number index for the range use with vba
any ideas?

Hi, hope you can shed some light.
I have a C# app which does some Excel interop. I didn't write the app
and I got e-mailed the executable which is used in production.
I then went and found the source code for it.

I have a piece of Code (part of several within the same module) that
mails out a spreadsheet, but I only want it to action if the value in
SheetA1 = Monday (A1 will actually be =Now()). If the Value in A1 is
not = Monday I just want to skip over the code and execute the remaing

I am setting up a Textbox with WordWrap=True.
I want to be able to go to the next line to enter MORE text, but i get taken to the next Textbox.
Is there a way to do this?
I noticed that although wordwrap=true, i still get 1 line of text across the top line???

I have a workbork that does a mdb query by Date Range. Different Date ranges
returns more or less data. I would like to have Column H to total up at end
of data. My Start of data is H5. Can someone give me some insight on how to
do this

I am writing a macro for a button. When I push the button, it should insert a
new row with 10 cells in a table and assign checkboxes to the last 5 cells of
the row.
In a macro how do I assign checkboxes to the cells of the new row ? Is it