I have about 25+ named ranges in my excel workbook. All of these ranges
currently end at row 250 and I want to increase this to 1500 for all
ranges. How do I do this programatically?
Any help is deeply appreciated.

In VBA, if I have the integer 7, how do I format column 7?
The recorder does
Columns("G:G").Select
Selection.Numberformat = "blah"

I need to find a way to keep users from entering the formula (=TODAY())
in a cell that requires today's date.
Cell validation doesn't work because the formula produces a result
within the accepted range.

On my spreadsheet I have a user form that loads up where their are two text
boxes on for the First Name and another for the Last Name.  With the help of
Tom I have created a macro that takes the input from the text boxes and takes
the user to their corresponding range.  

OS:  W2K SP4
app:  Excel 2000
I've written a sub in VBA to read in a file.
This works....

I need a help, I need to retrive data from a closed work book when i click a
command button.(Retrive data from 3 different cells) please help me out with
this VBA coding. Please Guys, It wll be very helpful for me
Thanx in Advance

would like to be able to highlight a range of cell then have the macro
calculate that area

I've been struggling with a project where I have to take hundreds of
spreadsheets with thousands of contact records.  Each record has a field
called "Title" and a field called "Job Function".  We have each contact's
specific title, but then we want to categorize them in the "Job ...

I have created a series of forms.
Example: UserForm1 and UserForm2
In UserForm1 I have a Command Button that has the code
  UserForm1.Hide

I am using Office 2003 on Windows XP.
I have a custom program for certain users, but as an error check, the
program  needs to determine if the activesheet contains a tabular list of
data. For ease of use and flexibility, I don't want the user to have to

I have 1 sheet which contains product name, buy or sell, price, amount,
trade date, counterparty.
for example :
book A - buy - $50 - 10 - 1 jan 06 - G

this macro doesn't compile on the HPageBreak.  It thinks it is a variable not
a method?
What I'm trying to do is force a page break above every department header
row.  Every lite gray row is a department header.  I want a page break at the

Sub Combine_M2M_Extracts()
'
'   Combine_M2M_Extracts Macro
'   Macro created 9/22/2006 by John F.  Scholten

I need to find a way to keep users from entering the formula (=TODAY())
in a cell that requires today's date.
Cell validation doesn't work because the formula produces a result
within the accepted range.

I have data in a form similar to this:
Date;SKU;Production
Date1;SKU1;Production1
Date2;SKU2;Production2