I am trying to figure out a way to check to see if the cells in a column have
6 characters and if it doesn't is there a way I can have zeroes inserted for
the cells that don't contain 6 characters in the designated column.

I found a file on the web today and looked to see what the macro was like to
learn from it.  There is some event code and a tiny in the SS.  When I
deleted all the code, the SS was still automated.  How can an Excel SS be
automated without any apparent macros?  

I have a list, let's say it is a list of 44,000 names.  I wish to print them
"2-Up" which means print Name #1-40 on the left side of page 1 and then print
#41-80 on the right side of page 1.  Then on page 2 print 81-120 on the left
and 121-160 on the right side of the page.  I ...

In an application that I am creating, one of the macros looks to see if
another workbook (from which data will be extracted) is Read Only. If it is
read only, control is passed to a msgbox advising the user to try again, then
the Sub ends. By the time the user clicks ok to the ...

Hello...I created a userform with several text boxes and three comboboxes
with lists which pull from a named list range elsewhere in the workbook.  I
was able to get the first list to drop on entry using:
"Private Sub UserForm_Activate()

I have a sheet with maybe 870 rows, of which some rows have red text.
I want to run a program which counts how many rows are red.
I have made the following program, and it is giving me a count of 10, when
it should be around 60.

Hi I have a textbox that user types in a comment and I want to limit the
input to 255 characters. I am using code as below but when I try to remove
the extra characters I get an error can some help please.
TIA

I'm moving from Excel 97 to Excel 2007 and some things have broken :-(
I have a workbook containing many worksheets. Some of those worsheets have a
Worksheet_Calculate routine more or less identical to this, a simple
GoalSeek.

I have created a toolbar, and assigned macros to the various buttons.
However, excel has added the filename to the macro assignment.
For example, I have a macro called "StartNewProject".
When I assign this macro name to a button on the toolbar, close it, then

I have one column that has list of phone numbers with area code. I
need to make new column for which state. I would like to make a small
macro program to check the area code and put two letters state on new
column. How do we do that. I was thinking to use loop for read each

I have this line of code:
MyStr = Cells(12 , "D").Formula
I expect it to return "=D11 + D7" but it reurns the the value Cells(12 ,
"D").Value

I am comparing 2 spreadsheets to find identical items.  I create a reference
column for each sheet.  Each reference number contains the amount of the
item.  The sources for the data in each sheet comes from different sources.
One sheet, the amount is a text field and displays as 1 ...

I want to finetuning my chruch records membership
With 500 members some names are 2 or 3 pieces words and now I want to put
them into separate names since I want to build a Access database instead of
excell

I'm totally new to macros in Excel and I'm hoping there's an easy
solution to my problem.  Any help is much appreciated....
Here's my problem:
I have a workbook.

Jim Rech pointed me in the right direction yesterday with a problem I was
having opening a workbook, and he suggested I look at the Notify option.
Being very green at syntax I have tried to code it like this:
Workbooks.Open ("\\..............NSR\Database\Dbase.xlsx",,,,,,,,, ...