1.
set rng=[a1:a9]
rng.select
with selection

I have a named range on one sheet that I want copied to another sheet
when it is Activated
How do I get the macro to enter the data from a Named range?
Buzz

For my headers on a report I am creating, I need to be able to center
justification and wrap the text.  How do I do that in association with this
code or before the code.        
ActiveCell.Offset(0, 0).Value = "Date"

I hope I can make this clear. I have written a script to extract data
from a text file to excel based on an applied filter. I wish to do a
daily extract to excel of the same data each day from text files that
are named by date eg 20080319.txt. How might this be possible? The

I have a wizard that is navigated using using buttons like, Back, Next, etc.  
I want to show the tab strip so the user knows what steps are next, but I
don't want them to be able to click the tabs themselves to change the page.  
I want them to have to use the buttons on the ...

Hi, I have no experience of combo boxes but I woould like one to filter the
value on a worksheet to be used in a macro.  I am trying to make the user
select the value from a list in a combo box called "dropdown7_change" which
is passed to a macro for filtering a field in a ...

I'm looking for suggestions on turning one of the schedules in my excel file
to millions.  This schedule mainly feeds from a pivottable using the
getpivotdata function.  I want the schedule to continue to be maintained in
whole dollars, however a few of my end users are ...

If the score in D1 and D6 are the same then in E4, I need to inlcude both
names (concatenate) like (John / Marty) else the formula below.  The
following formula works great when they are not equal.
I know the following concatenate formula works =IF(D1=D6,A1&" / " &A6) , but

Hi All,
 Why does a cell with a text value fail the Val function?
Background:
c1 holds   44 1st Sub Row   as its value AND is hyperlinked to a cell in row

Hi.  I am trying to mimic some MS Project functionality in Excel.  I want to
try and automate the creation of a basic gantt chart.  Is there a way I can
do the following:
Columns D - O are labeled months of the year.  Column A is a task, column B

I have macro (please see below) which is set on a button in a
spreasheet and it works fine. It basically add 6 rows and then merge
cells of those inserted rows from cell "I" to cell "N" and then sort
out number sequense in 2nd coloumn

I am trying to count all the numbers in a column that equal or exceed a
number that is entered manually in an individual cell (A1). But the countif
function does not work unless I enter the number directly into the formula.
For example:

I want to merge the two columns, sample data below:
CNM1GBLO    #N/A
CNM1GBLO    #N/A
CNP1GBLO    #N/A

Hi
I am an access programmer, so not entirely sure about using VB in excel.
I have created a small macro in excel and I want to put it on a button, but
excel will only allow me to attach the macro when i'm in the worksheet i

Hi
I hoping someone can help me with this. I didn't see anything that might help.
I'm using CutePDF Writer program
This is what i want to accomplish (hopefully in a Macro):