All,
I need to re-order some columns in Worksheet. Here is the code which
works just fine (to a point):
.....

Hi, anyone who can help me with thsi problem:
I have column with numbers:
1001
1002

Does anyone have any suggestions on how to use index function in coding macro?
myCell.Offset(0, 2).Value =
Index(B:B [under Temp worksheet],match("Industry",A:A [under Temp
worksheet],0))

How can I count time when I wrote not a date/time format ex: start/fnsh at
6/22.30-7/05.40 in the same month, and how in the diffrent month?
Thanks alot

help please

I am trying to add more than one IF and cannot for love nor money,
One sheet called positions where i enter details of positions placed. i will
enter 1 in a cell i want it to be 150 in another, if i enter 2 i want it to
be 100 etc

I am writing some vba code in Excel 2003 to use the histogram function
to make histograms of data in a number of different worksheets.
I would like to delete all existing charts in a worksheet and then
create a histogram and then modify its properties. I have:

I need help to complete a project.
It sort of works it just takes the last know value row that was true and
copy/pastes it not every row that met the condition as true.  It is also
slow, is there another way to speed it up.  I have updating false and my calc

How do I catch it if the user closes the GetOpenFilename window with the
titlebar 'X' so my code doesn't error out?

Hi- Could you help me determine why this program is not looping correctly? In
particular, the loop problem is that it does not open the next kregfile in
the for J loop.
Thank you!

Does anyone have any suggestions what wrong is the variable - Mywebsite on
following coding? The url cannot be assigned into Mywebsite variable.
Does anyone have any suggestions?
Thank you very much for any suggestions

I have the following code when a worksheet is started and the exited:
Private Sub Worksheet_Activate()
Dim cst As String
Dim xcell As Range

I am looping through a range of cells looking for certain criteria.
When one is reached, I want to copy the value into the next 10 cells
in the same row as the active cell in the loop.  I am trying to use
the offset property to do this but cannot get it to work.  Is this the

The following expression works fine and clicks CommandButton #1:-
   Call UserForm1.CommandButton1_Click
Is it possible to assign a variable to the number of the button clicked,
along the lines:-

Is there a way to have this condition read  in this one line.
IF cells(valid,13)>"" and (cells(valid,19)>""and
((cells(valid,19)-cells(valid,13))< 20 then
cells(valid,30)=cells(valid,8)&CEDissue