I have this macro :
Try:
Sub col_row()
v = Array(Cells(1, 2).Value, Cells(1, 3).Value, Cells(1, 4).Value,

Hi, I have the following code behind a userform that works, but I don't
think that it is the way to go with it. I have not gone any further than
this on the code. The labels on the form will have to populate from one of
16 different ranges, week one is B3:C18, wk 2 G3:H18 ect. ...

I have the following code for when the user clicks "submit" in a user
form.
The variable txtRFINum has be a unique number.  If not, I need an error
message and to exit out of this routine. The first empty cell in column

Hi everyone. This is my first post in these groups. Im a bit new to VBA
and I hope you can help.
I have been working on this macro for about three days. I can't seem to
figure out how to do this (primarily the part where it checks column A,

All:
I have a simple spreadsheet where a user can enter values into columns
A, B or C. In column D, I would like to place the current date and time
(NOW()) if the data in A, B or C changes in any way. Is there a formula

I have an 18,000 record database and every entry is a name with the
letter A added to the end. for example: Lastname, firstname       A
. I need a macro that will open the cell, backspace the "A" out of
there, close the cell for editing, moves down one record or line and

In Excel 2007, if you enter a number that is too big too fit in a cell,
it will automatically adjust the column width to allow the number to
fit.
I don't want that.

I have a problem with a spreadsheet when I am using a custom format
h:mm:ss.000 (to show milliseconds).
Column I is a time
Column J adds I to the start time

The below are values in seconds and milliseconds.
28.921
36.432
If excel adds these values I get 65.353 If I change the format to

I know this is not strictly and Excel question, but it does involve an
application I am developing in Excel.  I used mscal.ocx (version 11) on a
userform and when I look at the references it is located in c:\Program
Files\Microsoft Office\Office 11...no problem.  Some of my users ...

Hello, any help is appreciated. I have four cells (A1 thru A4).  I want
to display (1) in B1 if just A1 contains any text, or I want to display
(1) and (2) in B1 if cells A1 and A2 both contain text, or display
(1),(2), and (3) in B1 if A1,A2,and A3 contain text, or display (1),

I have been using Excel for many ears and often refer to the online help
when I'm stuck with VBA. No problems until today when it all seems wrong.
Last week I neded to double check something in Access VBA help and
successfully found what I was looking for, but now the Excel VBA ...

I am using a macro that takes some time. On the end, a userform must be
shown. In the userform I have to use data that are generated with the macro.
What happens is that one step of the macro is not complete before the
userform is shown. Therefore, I would force to the macro to ...

I have written a programme to find a previous record in my database
(presently on 35 records but will eventually grow to about 1500
records).
This is my search program (It finds the record that I want based on my

To all,
I have a worksheet where column A is a series of dates. These dates can
be in the format 2006/10/02 yyyy.dd.mm or 10/02/2006 dd.mm.yyyy. etc. I
want to be able to change them all so that they equal the dd.mm.yyyy