I have a question regarding refering to ranges.  Below is some sample
(and simple) code to illustrate my question.  I prefer to use R1C1
notation and the cells property.  But I have to use the A1 notation
when I set the range "r" in the code below.  Why can't I replace that

I have the following macro to sort a range of cells :-
   Range("A2:J5").Select
   Range("J2").Activate
   Selection.Sort Key1:=Range("J2"), Key2:=Range("I2"), Key3:=Range("G2"),

I have a macro that will take data from an existing spreadsheet and copy
certain sheets into a new workbook. It then pastes these sheets as values.
What I want to do is save this new workbook and base the file name on the
original workbook and then add the text "(Values)" after it ...

I have to save a file using 'todays' date in the filename.  I had to change
my system settings in order for the macro to work on my desktop.  Runs
properly.  I am being moved into a different position, and now someone else
is going to be having to run this macro.  Is there a way ...

i  have a form which i created  using vb editor. How do i manipulate it
so that while in run time a user will be able save the form on their c:
drive.
I am fairly new at using vba. I am more familiar with  vb 6. I notice

G'day there One & All once again,
    I've got a small problem in what was supposed to be a quick
worksheet to manipulate a shift roster. I've managed to get most of my
ideas to operate in the real world and it was kind of coming together

When I protect my excel sheet, I am no longer able to see the contents
of the cells in the formula bar even for the cells which are not
locked.
Is there any way to achieve this in Excel 2000?

In Sheet1, I have Cells A1:D1 "Merged & Centered" with bold letters for
the title of the page
I am trying to write a macro top copy and Paste the Text from A1:C1 to
Sheet2!D2 (after inserting a new column in D2)

Here is a major problem i am facing. I have an Excel file which has data
with quite a few formulas. But after i have done all the work, *save*
the file, close the file and try to open again, it won't let me do
anything cos it is calculating all the cells. Even if i ad a colum, it

How can I see if a workbook is Shared?
Is there a flag i can look at?
thanks for your help
jahrens

I have data in a worksheet, in which the main distinguisher is the
manager name.  I want to create different files for each manager.
How can this be done.
Thanks

Hello NG,
I have on a userform a listbox. The multiline property of the listbox
is true because the user should select more than one item. I want to
show the user an extra dialog about an item if the user makes a double

I have a spreadsheet that contains simple macros that I need to share with
others.  The spreadsheet contains thousands of records.  The premis is this:
My company dumps these records into a spreadsheet.  I send the spreadsheet
to a contact at one of our client sites.  She posts ...

I am using the macro1 to grab values from a closed workbook.  Column Z
contains text cells, many of which have text strings of approximately 1000
characters...so I am running into problems with the 255 character limit.  Is
there a way to modify the “Looper” macro at

I have formulas going from a2:a1000, when the value (Part Number)equals zero
or N/A the cell remains blank. I then sort the data so that the values show
starting from a2 down to where ever.
I am looking for code that shows me the last cell with a value in it,