I have some code that needs to refer to ranges a fair bit and was
wondering if there are any differences speed wise between
(a) referring to named ranges ie.
                          x = range("Name")(j,i).value

i have 2 cells,
---Time----Day----
--640------Mon---
how do i copy the 2 different data from 2 different cells into 1

I would like to have a user enter values in a form and have the form display
calculated value (based on some of those entries) after a button click, then
add all the values (included the calculated one) into a spreadsheet.
How can I do this?

I'm transforming some Excel data into Word tables. I'm quite familiar
with Word VBA but having some difficulty with Excel. (This inexperience
may explain why I feel Excel's VB is flakier than Word's.)
One problem I've just encountered is this test:

Here is a macro that works. It will find a record in a sheet named
Official List via a PO# given by the user.
Sub FindFirst()
'This is for the PO/PL search via UserForm12. Clicking the OK button

I have a user form with text boxes that request dollar values.  How can I
format the text box as currency when the user enters an amount?
Thanks in advance for any help.  

I have searched help for the proper usage of cell commands but have not been
able to identify anything that allows me to select a cell, and by means of a
macro, select the adjacent cell and invoke an insertion macro I created.  
It's the selection of the adjacent cell that is ...

I have the following code on a page to pop up a calender when 1 of 2 cells
are selected and then the chosen date fills the active cell and disappears
when a cell outside the range is selected.
My question is - is it possible to modify this code to do the same with a

Need help with a macro I can not for some reason get to work what I am
trying to do is copy cells "AF78:AJ78" and then do a copy, paste
special to "AF81:AJ81" and
then calculate "rand() " and copy "AF78:AJ78" again and then paste

Having recently converted to Excel 2003 from '97 I'm slightly stumped.  I
need to add a reference to another one of my XLS files into my VBE
environment.  When I click on Tools though, the References button is grayed
out.

I have TextBox1, CommandButton1 and CommandButton2. When user inputs a number
in TextBox1 and then clicks CommandButton1, I need that number sent to
"Sheet4" Cell "B2" and a msgbox stating that "Whatever number was entered had
been added to your Vacation". If CommandButton2 is ...

I'm trying to figure out the easiest way to do this.
I want two copy a set of data from two different workbooks and merge it
together into one workbook.
Book1   Data1

I have a button which kicks off a VBA method which either hides or
unhides rows on a Worksheet.
I'd like to protect the worksheets but if I do an Error 400 occurs when
the VBA attempts to change a row's status from visible to invisible.

Is there a way to set the a sheet's ScrollRow without making it the
ActiveWindow and assigning the ScrollRow to the ActiveWindow?
In other words set a ScrollRow value directly from a sheet.
Thanks.

I would like info on how to create a formula where you can use a range of
letters to indicate varying values that Excel will recognise. These values
have to be written in one cell so that Excel can determine the value.
For example, A=12, B=10, C=7.5.