I need to fill some cells using results from a custom dialog.  I need to use
a different dialog with some cells and need a way to differentiate which will
be selected based upon the cell.  This needs to be a bit dynamic so that it
can be changed if the format of the form is ...

I have a work sheet with 65,536 rows
only the first 12,000 of which have data,
but I can't figure out how to delete the empty but active rows.
I could do a reverse Find from the end and then delete the trailing Range,

I have a userform with a few textboxes, all of which run the same
code.  I was wondering if there was a way to link them to the same
section of code.  The code each one runs is below:
Private Sub TextBox1_Change()

I appreciate any help anyone can offer with this project including someone
who I can hire to get the task done because I'm not sure I'm up to this level.
I have an event which requires a liability form be signed by the
participants. One by one I wish to have a participant view the ...

In an excel 2003 spreadsheet, I want to allow data entry to specific cells.
What I would like to occur is when data is entered in a specific cell, the
curser will go to another specific non-adjacent cell. Example: Cell D4 -
after data is entered and the enter key is hit, curser ...

with the following code I get run-time error 1004 with the above description:
Set pt = ActiveSheet.PivotTables("Pivot_Table")
Set pf = pt.PivotFields("Pivot Class")
With pf

' Save And Close
 ActiveWindow.Close savechanges:=True
this closes and saves to workbook but leaves Excel still running, I want to
close Excel as well.

I came across this macro to insert, copy and paste a row. Is there a
way to modify it to insert, copy and paste 2 rows?
Sub AddRows()
Dim lastrow As Long, i As Long

Hi, I have recently installed Excel 2007 Home & Student. Unfortunatley
everything seems to take 10X longer to do. Any suggestions as to what I can
do to speed this up. I have done everything I know to do on my system setup
ie Deleted unused programmes, defrag, disk clean up etc.

RecordsDate = InputBox("Please enter Bank Records Backup date (m-d-yyyy)of
file to recall", "Bank Records Recall")
   On Cancel GoTo XIT
Below I have a line XIT:

I found this simple code (below) to place the date and time my file was last
saved into cell "A1".  I like it a lot, but now I need to put the date and
time the file was last saved into the center section of a footer.  How do I
specify that placement?

I have the following macro.  I desire that it copy from "Orders" to
"Pofit_Loss_Statement" the value in "ID" (a drop-down list) and paste it into
the first blank line in the Profit_Loss_Statement.
The code works fine as long as I stay on the Orders worksheet.  Once I

I have a few workbooks which when opening, includes a message whether I want
to enable or disable macros, yet there are no macros associated with the
file. I've gone into VBE to try to remove the macro, but no macros show up.
Any clue on what to do to remove the macro?

I wanted to search whole sheet for letter  example "http:" in sheet 1
then after that collect the data next after http: and put it into
sheet 2. Anybody pls help how to do in VBA code?
http://e-forextrading.blogspot.com

The following code was posted to the programming DG a while back:
Sub Redundancy()
Dim iLastRow As Long
Dim i As Long