I need VB code to Randomly generat numbers from 1 to 52.  Can anybody
help?

Hey everyone,  I need some help.  I have tried everything I can think of
to enforce this, but I keep running into errors.
Any values in column B or C I need to have a specific format "### -
########## - ######## - ##/##/####"

Group,
It seems that many contributors who help us less experienced users
always seem to reference another locaton for assistance.  I guess this
query is one to ask all you VBA guru's what are some of the best Excel

In my office system, I am running XPPro SP2.  I have one printer attached
locally to the computer but I have set it up as two printers, each with a
different "profile".  One "profile" prints on a single side and the other
prints double sided.

I have a range of an array entered (Ctrl+Shift+Enter) formula that is
calculated using a function in VBA.
The value of each cell depends on inputs from other worksheets. I find
that if I change these inputs, the array entered cells will not

I need to send an Excel spreadsheet that I have programmed with quite a
bit of code to a number of my companies offices. I really don't want to
have to explain to non-excel-literate office staff all over the place
that they should go tools / macros / run / etc etc to make it run, ...

Group,
It seems that many contributors who help us less experienced users
always seem to reference another locaton for assistance.  I guess this
query is one to ask all you VBA guru's what are some of the best Excel

I'm developing a VBA macro in basic.  I compile the VBA code then
execute it.  When I have a run time error a window pops up that says
"runtime error <someNumber> <some error message>" and OK button.
That's great.  But what I would like is to also have the debugger

I'm trying to create charts of various data sets using a calculated
dynamic range. However "SetSourceData Source" seems to be limited in
the types of expression it will allow for ranges.  For example:
ActiveChart.SetSourceData Source:=Sheets("One").Range("D5:E29')

I would like to display dates in a pivottable that match with dates on a list.
I am one step away, but not sure where I made a mistake
'count number of dates in a pivot talbe    
intCountRows1 = ActiveSheet.PivotTables("PivotTable3").PivotFields("Date").

Is there a way to determine if a single cell is in a named array?
For instance,
In B7, I want to know if B3 is in a range called "Jan"

I've been developing an XLL that creates several new menu items in
Excel, each registered with the same command. This command is defined
by my XLL, and uses xlfGetCaller to identify which menu item has
triggered it. It then executes a C function that I have associated with

In the following code I'm copying data from a worksheet (QuoteForm) to
another workbook called Quote Log Temp, worksheet TempQuoteLog. The
code works great, no issues at all. But I'd like to change it slightly,
but I'm struggling with how to do it.

I am new to Excel spreadsheets, does anybody no the difference between
Vlookup and Hlookup,
                                  cheers for any help.

I'm writing a macro that finds a text string in one spreadsheet
(wsExtFrom), then copies that entire row to another sheet (wsExtrTo) in
the same workbook. It copies to row lExt2Row. I can't seem to get the
syntax right.