I am getting 'Subscript out of range' errors with this code.
The project code is to enable me to create new wbooks from each wsheet of
the current wbook.  To do this I read the tab names of a wbook as it is
opened.  The number of tabs can differ and their names need not be the

I am using the following code to name a new sheet:
Dim sheetName
sheetName = ActiveCell.Value
   Sheets("Sheet1").Select

My question involves an Excel input file where people are supposed to enter
certain data ONLY on Thursday thru Sunday.  
(1)  On Save, ThisWorkbook code checks the day of the week, and if it's
outside that window, opens UserForm1 with a reminder message.  This works.

I have to modify an excel template that is currently using the columns
and rows of the spreadsheet to make calculations. The problems is
people decide to change the columns every so often. I am new to vba and
I am trying to figure out the best method for me to use the header name

Hi,  
I am trying to delete entire rows based on a condition.  My condition is
simple, I put the word "delete" in column b of the worksheet.  If it has
"delete" then wa lah!  Its supposed to be gone.  Except I can't figure out

I've found this macro and I wonder what might need to be changed to do what I
want to do:
http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm
Private Sub Worksheet_Change(ByVal Target As Range)

I have to remove quotation marks in a txt-file during a certain procedure.  
How can I do it using excel-macro?

I have a class that I made, called clsPicCell. Each clsPicCell object
has a two objects within it, a range object and a picture object (both
private objects).
I would like help on how to be able to delete a clsPicCell object, call

I am trying to create a spreadsheet in excel 2003, which has a toggl
button on it. When I press the button, I want the sheet to display tw
different sets of data, for example, display data in ColumnA and hid
ColumnC and vice versa.

New to excel VBA: I have a formula in my cell range of J2:lastRow
=IF(ISERROR(INDEX(Clients!$A$2:$A$296,MATCH(LEFT(RIGHT(C6,LEN(C6)-FIND("/",SUBSTITUTE(C6,"-","/",2),1)),5),Clients!$A$2:$A$296,0))),"",INDEX(Clients!$A$2:$A$296,MATCH(LEFT(RIGHT(C6,LEN(C6)-FIND("/",SUBSTITUTE(C6,"-" ...

The original question is as follows:
My access database has 100 fields, I have to output 4 of them, but unique
into a excel sheet combobox for free picking up. User can start from any of
the 4 combobox, and the rest three will update and refresh according to the

Quick question. How do I get the value of the bottom cell in a certain
column (actually always column A)?

I am writing a macro for the user to input a numeric value into a tex
box. Is there a way to check to asure that the input value i
completely numeric?
thank

I have a spreadsheet containing a list of products for reference purposes.  
This list will often be utilized by searching for data in one column to see
if it exists and in many cases there will be multiple matches.  
I can do this by using a Custom auto filter using the "contains" ...

I´m making a Worksheet to calculate the Residual Value of car at the time
the worksheet is open.
So i have colums with the "inicial date of the contract", "Final date of the
contract", "the monthly rent", and the "car value when purchased".