I have set ranges many times. Usually I set the range for more than one cell.
In this situation, I just want to use one cell.
If this code works:
Set count_range = Worksheets("Inventory").Range("L4")

I use this code to save over a file with new info;
ActiveWorkbook.SaveAs Filename:= _
       "H:\Shortcuts&Links\M Y  P R O J E C T
S\NationalSummary\DPR_National_Summary_Daily.xls" _

I have a custom collection called Myworksheets.  I want to load a certain
sheets into this collection.  The syntax below works.  I have two questions:
1) Can someone explain the syntax to me.  Not sure what the difference is
between the sheet name in the bracket and the sheet name ...

Dear Sir,
I prepared one Userform, I want to validate the text field like this.
SEP<SPACE> 08     i.e.   SEP 08    in capital letters.
what is the code for this purpose.

I am not able to enter this " Private Sub Worksheet_Change(ByVal Target As
Range" more than once in the sheet code of any particular code.
Once I am entering any macro starting with this it says ambiguos code, I am
new to VB kindly help me out.

Greeting,
I am confused over how to make a variable to be variable.
I am running Office 2003 on an XP Pro machine
I have a set of 21 variables called Rng1, Rng2, ... Rng21.  these

Hiya
Already submitted a question but think I may have bn looking at the problem
wrong, so gonna try a different way but I'm clueless when it comes to VB,
once I have run a macro I want to edit it so that it goes to the available

I need help for some code.
I want to use the 'ENTER' key to behave differently when the selection
change on some columns.
Let me explain.

Im querying a SQL 2000 DB and trying to use conditional formatting on the
fields that the data from the DB is in to change the background colour. The
conditional formating wont work on the fields with the DB data but it works
fine on other fields!?

I have this code, I wrote.
I am not very confortable with VBA, so I have a problem.
When it arrives at the last line it gives an error. Run-time error, 91 :
“variable not set”.

I use this code to copy a worksheet from one workbook to another:
With wbkExport
   wbkCurrent.Worksheets("Output").Copy After:=.Worksheets(1)
End With

I have a function that creates new custom workbooks for each client and
distributes them across a network.
How can I get a macro automatically placed in the OnOpen event of each new
workbook when it is generated?

I am creating shapes, but the user can delete them. Then if the VBA code
wants to updat the shape with some information in cells, the code should
check if the shape exists and otherwise create it.

How to set excel function or formula such as SUM function to add up
the range of selected cells which gives the result excludes hide
cells, particularly for long range of cells in a column ?
E.g.

is there a way to find the number of the office service pack installed?
I know about "application.version" and "application.build" but those do not
give me the information desired...
thanks!