I am currently developing a template in excel. I am new to VBA and
have been slowly learning it since last week.
Here is a brief description of my template. Many thanks to everyone
who can provide suggestions and help me figure this out.

Is there a way to set a named range, based on the active sheet?
Example:
Range1 =LOOKUP(2,1/('Sheet1'!$B$1:$B$5000<>""),ROW('Sheet1'!$B$1:$B$5000))
I want to be able to set this named ranged, based on the sheet I am in.  If

Our Ops department here would like to take advantage of the dynamic
capabilities of Pivot Tables and Pivot Charts, in order to present Load vs.
Capacity planning data.
The Load dea is in an Oracle database, and the Capacity data is in an Excel

I have a macro which uses the solve function to solve for various cells in
my worksheet. The problem is I have noticed whenever I am working on my sheet
and insert/delete a column and/or row my macro's cell reference values do not
change automatically. (Like a formula within a ...

i have number of commnad buttton in embedded in a sheet
i want to shift to a combobox
please guide me

I’m trying to push several values from an Excel sheet into a Word document,
using VBA in Excel and bookmarks in Word.  Below is what I have so far:
Sub PushToWord()
Dim objWord As New Word.Application

I am learning how to work with opening excel workbook files.  I am getting a
run-time error 9, supscript out of range.  I know what that means but I don't
see why I am getting that error.
There are 6 files in the directory and I am only processing 0-5 which is six.

Is there a way to locate an ActiveX control (specifically, a button) in a
spreadsheet, i.e., to find out what column it is in?  I can figure it out if
the control has a linked cell that I can put in the same column, but that
doesn't work for a button.  Although the 'location' of ...

Is there a way to locate an ActiveX control (specifically, a button) in a
spreadsheet, i.e., to find out what column it is in?  I can figure it out if
the control has a linked cell that I can put in the same column, but that
doesn't work for a button.  Although the 'location' of ...

I am getting the following error message with this macro: Wrong number of
arguments or invalid property assignment It works fine when I only reference
1 sheet but doesnt run when I reference 2 sheets.
Sub DeleteRowIfZeroInA()

I am writing VBA on a works computer, so I dont have admin rights etc on the
machine, so any solutions need to take that into account. The workbook is
under 1mb even when populated and the code runs in single step mode and 9
times out of 10 when run normally, but from time to ...

when I input an excel spreadsheet it is showing up as having 0 bytes, this
isnt happening all the time but is becoming an issue...any ideas?

I have a program which terminates with a variable length column of numbers.
In an adjacent cell I want to enter tha largest and in another cell I want
to enter the smallest of the numbers in the rsulting column.
The column name is the variable "tstC" the topmost row in the column ...

What are the precise steps to enable macros in an xl2007 file?
Thanx,
Alan Beban

In cell V7 of my worksheet I have the following formula:
=SUM(E7/Sheet1!$D$26)*52
What I would like to do is copy this formula down to line V501 without
having to copy and paste. I also have this same formula in 7 other worksheets