I have a large macro with 100's of lines of code, sometimes I need to run
half of the code. I stepin the macro then have to drag the yellow arrow
100's of lines down, Is the a way to start the code somewhere in the middle
without draging the arrow down all those lines. I've ...

I open a workbook which has a different name each month - against this
workbook I run a PERSONAL.xls macro which requires that workbook
"Employees.xlsx" is open in the background.
How can I as first item in the Personal.xls-macro open this "Employees.xlsx"

I have an Excel sheet that one of the workers has created and it must be
imported by column (number of columns varies).  The pattern is simple, there
are groups of three columns repeated for each data header.
In one of the columns there is a value that looks like -9:49  (9 hours ...

Hi Group,
Have problem with the code below. LookupRng1 and LookupRng2
are columns with dates formatet as YYYY-MM-DD. When running
the code the result is that no dates are found.

Two cells are highlighted with a1 =1 and a2=2.  I see the plus handle and I
drag it to a50.  Instead of putting the serial number - all cells a1 to a50
shows value 1.
using Excel 97.

I have an array (Array1) of values derived from an Excel range
Is there some function for knowing the number of items smaller than a
certain value without looping (something like CountIf for a range)?
Thanks

Hi I have made a spreadsheet to calculate golf scores and do
countbacks, the spreadsheet works fine but not knowing much about vba
programming I am wondering if a
user form can be used to enter imformation on to the spreadsheet but

I have form that has a number of list boxes that use command buttons to
transfer items from one list box to another, I want to save the items to a
sheet with a command button. Can do this with a text box but not with a list
box. Can some one give an example?

I would like to have the cell format set as text but display numbers
like $123,456.1234  while still having the data be just 123456.1234
I know that it would be easier to set the cell format to number, but I
want to manipulate the data and the number format messes that up.  I

Please have a look at the 2 subs below
Private Sub POLines_Change()
   UpdateTransferButton POLines, AddPSLines
End Sub

I am new at Excel. I have on a worksheet 5 check boxes (A3 to A8)
I have them linked to B3 to A8. When a checkbox is activated in A3 then B3
shows "TRUE".
I am trying to make sure that only one of the 5 checkboxes can be activated

I want to make a form button click a cell that has a hyperlink in it.  Range
("B4").Select simply moves my cursor to that cell, but doesn't activate the
hyperlink.  How do I activate the hyperlink?

How would one write a macro that makes a copy of a workbook and places it in
MyDocuments Folder? The macro also needs to delete one worksheet.
Thanks

Hi
Is it possible to have only the menubar visible on startup with an Excel
workbook? if so what would the script look like?
cheers

I have a large number of workbooks where I need to perform VBA code
maintenance.
I am updating all the code in the workbooks by first deleting all existing
code (modules, forms, worksheet code modules) and then import in the updated