I've just started a new job where Mac OS X is the platform used for all
their computers. My work involves using Excel a great deal, but i'm having
some troubles getting adjusted to the Mac version of Excel, so I would
greatly appreciate it if someone could help me out on the ...

I've been browsing this forum for the better part of today and last
friday, so I know this question has been asked and answered already,
in a variety of ways.
I'm afraid I am at this point still too much of a novice to employ the

I'm having a problem with sorting my Data.  When Excel does a sort, it
does not include hyphens.  So MV-2 would come after MV1.  But later,
when I try to import new data, I am doing a binary search.  In this
search, MV-2, would be seen as less than MV1, because a '-' is less

Am a bit of a usrform/ vba newbie so dont even know if im in the right
forum, but here goes anyway. The problem I have is this:
Would like for a userform to pop-up when the selection january!F4 is
changed. The userform will ask user to fill in the dates for that

This morning I posted a question how to copy lines with a specific
value to an empty sheet.
I got a promt reaction including the below statement but when running
the macro I am getting an error on .Rows(i).Copy

Can you do a conditional formatting of the adjacent call based on values in
current cell..e.g. if value of A1=0 then B1 cell color should be red

I am trying to have VBA evaluate the range C3:C100 (name defined as
Type_of_change), and if the value "TEST" exists in any one of those cells,
call Macro A, if not, Call Macro B. How do I get VBA to evaluate the range?
Thanks

Can someone advice me which VBA statement to use for substracting a
range of lines that match with for example the value in column A, and
subsequently copy them (whole line) to an empty sheet (say "Sheet2")
Lookup value in column A: CCC

Would anyone have some idea why this don't work - please ?
Private Sub App_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean)
   For Each wk In Wb.Worksheets
       wk.Calculate

Please help if you can. I can not find an answer anywhere.....
I have created an Excel form (*.xlt) file that will let a
user add a record to a database.  In order for the user to
add the record they manually have to "Save As" the form.

I created a form in workbook1 that will access all open workbooks.
This is my problem I have 2 listboxes; listbox1 is in the
UserForm_Initialize() event which adds all open workbooks to it. Now I
need, when a workbook in ListBox1 is clicked it adds all worksheets in

Hi - I want to put formulae in cells in my worksheet based on
itterating values.
For instance:
   =sum("A2")

Hi,
I have several worksheets with data. I'd like to specify a column and
wherever there is a 0 value in that column, the macro will delete the whole
row it is in. The column to look for the 0 in is different in each of my

I have a UserForm called ChangesDialog that I have loaded literally 100's of
times. All of the sudden I am getting a "Run-time Error '424': Object
required" error message and the first line "Load ChangesDialog" is flagged.
Private Sub Main_Button6_Click()

This seems simple but I can't seem to figure out how to do it.
In a worksheet I have a cell into which today's date is entered automatically.
Using =Now()
I want excel to give me the next three business days (i.e. next 3 days