I have a variable assigned a value as follows:
Dim MemberNumber As Integer
Dim MemberName as Text
MemberNumber = Cell

Hi, I have 63 separate files which are sent to our stores each month
and returned, and are identical in format. I have password protected
them also so our sites cannot alter the layout.
Each site name is entered in cell B17 and I have created a comments

T created a spreadsheet with a Date column and want the format to be 02/19/06
but I want to be able to type in the six digits without typing in the slashes.
Typing in today's date of 021906, you get 12/22/59, the 21,906th day of
(last) century.

Can anyone please tell me how I could calculate FFT (Fast Fourier
Transform) of a certain range of values in excel? Any sort of help
would be greatly appreciated. Even if could point me to some place
useful, I'd be grateful. I've tried googling but have had no luck

I thought I was finished with my project... and then my boss stepped in.  One
more thing!  :o)
Here is what I have:
Col A = Mark

I'm trying to accomplish the following:
- Concatenate 4 Worksheets into 1 data sheet
- Sort the new data sheet
I have a separate worksheet that has a command button for initiatin

I know that I can select the areas selected by using:
Selection.areas.count
Is there a way to know easily which areas are selected one by one?  For
example, if I select columns A, C, and E, the above will be give me

Each month I update hundreds of reports (Excel Workbooks) and place
them on a shared network drive (K:\Library).  To facilitate retrieval
of these reports I built a Report Selection menu.  This is an Excel
file with a UserForm and numerous VB controls to select specific

I have a command button on sheet1 of a work sheet, part of what it does
is copy a range of cells to sheet 2. The code I am using seems rather
crude
For j = 1 To 2

Is there anything in Visual Basic that is similar to SYMBOLIC CONSTANTS as
used in the C Language. For Example, in C:
#define AAA sheet4.cells(35,6)
Sub SomeSub()

Can I use VBA to get Google to search for the contents of A1?

I am currently trying to follow the progress bar instructions from the
j-walk.com website. However I am struggling to understand the reason(s)
why my progress bar's form window goes white.  
The funny thing is that when I insert a breakpoint on the line where

How do I write the code to return a page number within a given worksheet, so
that that number can be used (1) in an expression or (2) to cut, paste,
delete, etc the page? Also, the code to return the number of pages in a
worksheet? Thanks very, very much for any assistance.

in excel, i take a range and paste it it into a chart with a copypicture
command in vba. then, i call on ppt and when paste the chart which includes
the pasted range in it, on powerpoint, the range that was pasted in has
shifted to the left. any solutions.

Is it possible to write an "If/Then" procedure that evaluates if a give
cell value is equal to any cell value within a range of cells the
return the value of another cell in the same row as the equalled cell
e.g.