I'm just starting out...
How do I get my macro to use the active worksheet.
before I used the filename:
With Workbooks("Calculatron.xls")

I am trying to get access to folders on a server that normally the user will
not have permission to access but do want to allow access to this XL
workbook irrespective of the user. That is I want to be able to read/write
files in a folder programatically from an XL workbook ...

Thanks to a lot of people I have nearly got my work duty sheets up and
running.......but i've hit a snag.....
I have everyones start and finish time........finish time - start time =
hours worked.......

I have a code that inserts a number of rows based on a number that is put in
on my spread sheet and it works beautifully thanks to Martin Fishlock,
however, I would like to have the formula from the rows above to be auto
filled in the newly inserted rows. Any help would be ...

I open a workbook, hide it and want to read some values from it.  I
want to read a data within a range on each work sheet.
It try the following and it says runtime error 9 subscript out of
range.

In excel I have created a user form, in which there is a label
("nonfincalcLabel").  I am trying to change the Caption of the label
based on a calculation using Vlookup when a change is made to one of
the comboboxes.  The lookup table range is defined as "nonfinRange" in

I am using a custom component to render multi-tab Excel spreadsheets.
However, ever so often I will come across an error when I open up the
spreadsheet. An error message saying "problem during load" will appear
and when I drill down I find the following error:

I have a spreadsheet set up as the following:
In Column A1 I have salesman names.
In Col B1 I have each individual unit sale with a sum at the bottom.
Example:

I'm trying to interlace rows of sales numbers from one sheet with
forecast numbers of a second.
Get 1st item from Sh1, find that item in Sh2, copy adjacent cells,
paste into Sh1 adjacent (and one row lower) to the item there.

How can one discern what column is being referenced when a filter is on?
For example,  ActiveSheet.AutoFilter.Filters(1) might refer to what COLUMN
or RANGE when .On is true?
Thanks for your help.

I'm trying to configure scroll wheel mouse settings by application.
The settings I apply to Microsoft Excel do not carry over the the VB
Macro Editor when I launch it from within MS Excel.  Does anyone know
if there's a .exe associated with the VB Macro Editor?

I have a project management spreadsheet I acquired some years ago that
isn't complete.
I'd like to have it work properly, but I don't understand vb programing
well at all.

I am working in an Excel sheet where data is dumped from another system.  
Many of the rows are extraneous - if the cell in the Current Hours column
(AB) contains a zero value, I'd like my macro to delete the row.  Someone
here at my office knows more VBA than I do (which is very ...

I have a for each loop that loops through a range of cells. My  problem
is that if my criteria is met I delete the current row. The problem is
that the for each loop moves on to the next item which is really 1 more
down now that I deleted a row. How can I make it recheck the current

I have two arrays first one is dates (F6:AK6) the is the number of
items (F7:AK7)
while items can be negative in order to remove item from inventory I
need to count number of days