How would I select (and I do mean actually select the row) the last row
that has data in it?
I need to be able to say:
LastRow.select in essence and then do whatever I need with that row.

I have the following problem...i have create a userform2 in sheet2 with
a button that takes u to sheet1 and at the same time activates a unigue
userform1. Userform1 has the capabilty to perform a few simple actions
in sheet1 and the moment you _terminate() userform1 it takes u back ...

In my VBA programme I select a lot of different ranges.  At presen
Excel shows these range selections on screen.  This makes that the use
gets to see Excel jumping from one sheet to another during th
programme's execution.

I am importing a bunch of data, and the first field is Record #:   I
want this field to increment with each imported record.
So the first line would be record 1, second line record 2 etc etc.
Anyone have some code that will do this?

I am having a great deal of difficulty doing what appears to be a simple
task.  I want to add a List Box from the Controls Toolbox and then set some
variables.  I am using the following code:
   ActiveSheet.OLEObjects.Add(ClassType:="Forms.ListBox.1", Link:=False, _

Hi all.  I am brand new to VBA, and am fumbling my way thru this.  Any help
is appreciated.  I have one worksheet with several thousand rows, and about
10 columns.  I need to loop thru all the rows in column 5 to see if each cell
meets a certain criteria (is the text there = ...

I am working with a large database and it would be too difficult to make a
function like "=if(b13253=b13254,d13254)". I am trying to find a way to do
something like this   "=if (2.row()=2.row()+1,4.row()+1".  where the 2's are
column b, and the 4 is column D.  I am unaware of the ...

Im looking for a code sample that will look at a list in excel and pull
out entire rows based on referenced cell critera and paste those rows
into seperate sheet within the workbook.  Anyone have something like
this that they have done before?  Any help/direction is greatly

I Want the code to get a ComboBox or DropDown Menu on the excels
Standard toolbar.
Intention is run all the macros with the help of the  ComboBox or
DropDown on the standard toolbar.

I have created many macros to automate many things what i do day to
day.
I know how to assign a macro to a button.
I want to create a macro to call these buttons always when ever excel

I'm using this code to open a database connection using ADODB inside VBA.
What I would like to have is a dialog so that users must enter their
username, password and DSN name. I don't like to have this information
written in the code. I know that I can protect the code but still ...

I have created many macros to automate many things what i do day to
day.
I know how to assign a macro to a button.
But I dont know how to make available all the macros when ever the

I found a number of posts relating to this, but ain't yet seen nothin'
of any consequence, so..
Even though I clamped down on the modules / sheet changes with
Application.ScreenUpdate = False

I have a problem when using a macro to set size of a chart. I acnnot use the
macro recorder so I want to be able to set size in code. My code is:
Charts.Add
ActiveChart.ApplyCustomType ChartType:=xlUserDefined, TypeName:="Standard"

I have the following macro but it won't work, because, what I think
the backward counting "For i = 10 To 1" doesn't work.
Is there a solution for this problem so it can count backwards o
change the names of the ComboBoxes from 10 to 1 ? Thanks in advance!