I need to determine and then store the row number of the cell that has been
selected in the active workbook.  Later, after running some additional code,
I need to select the cell in column A using the row number that was stored in
the first step.

I have a macro that formats column data and imports it into an access
database. The data is scanned in with a barcode scanner. The problem is i
have to hit enter in between each item. All items are the same length. I
would like to see if i can format the data in a row to a column ...

I have a function in my spreadsheet and I would like to know within that code
what cell the function is being called from, but I have no idea how to
achieve this. Perhaps somebody here can point me in the right direction?

Hi, sorry if this is an obvious question but I can't work it out.
I've created a userform that wants displaying on a worksheet as
default, how do I make it display?
I don't want it to appear when the user presses a button or anything,

We have written an extensive programme using excel & VBA. We use a
combination of calculations & lookups in excel for some of our database
equivalent functions & VBA to control loops, data entry etc.
Due to different versions of excel & trying to distribute our software to

Set r = Union([a2], [a4], [a9])
r.FormulaR1C1 = "=r[-1]c"
r.Value = r.Value
i want to chang result value of function of non continuous cells to

I've cloned and adapted a vba code and designed a userform that does the
following:
Displays in a userform list box all the worksheets in an active workbook and
the number of rows in each sheet that contain data.  When I double click on a

How does one automate Internet Explorer when a web page has Java Script in
it?  
I have working code for a macro within Excel to automatically do things for
regular HTML, and I can find names of boxes within the source for that.  

How do I select cell L4 to last cell?

What is Addin Tools If we want to add one macro in Addin Tool so how can I do
it.
Microsoft Community has given me the script of Number to word file and its
working now how can I Add in Addin Tools.

I am trying to come up with a way of comparing two ranges, which will change
over time, and put together bits of code to create the macro below:
Sub Compare2Shts()
   Dim rRange As Range

I am having intermittent problems with the Text property
In A1:
=rand()
In A2:

I converted an Excel 2000 spreadsheet to Excel 2007, to an xlsm file
(macros allowed).  It has a very simple Worksheet Change macro stored in
the code "behind" one of the worksheets:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)

I am sure this is something obvious but its driving me mad....
I have a workbook with control buttons on several sheets to run various
macros. It all looks fine to me and also for another user, but for one
particular guy when he opens the workbook the buttons on the sheet first

I have a macro that I recorded to update an external range named
Ralston_SupplierInput.  The data come an Access db.
Here is a piece of the code:
'Move the the sheet containing the external data range