I am trying to write a program to add checkboxes and delete certain
checkboxes in a row.  How do I delete certain checkboxes.
Thanks

I have a number of text cells and I need to be able to truncate a number of
characters from the left hand side of the value. eg. MB99_Prod_PGP_Trans
needs to be truncated to "_Prod_PGP_Trans"
I am having trouble trying to find the VBA code to do this.

In a spreadsheet called FileList I have a list of files in Col A like this:
C:\Documents and Settings\##My Documents\My Things\Blah Blah
Blah\Folder_2\01 Filename
In Col B I have the new file names like this:

The following macro will create a value in cell A2 that has more than
32k characters.
Sub foo()
   Range("A1").Value = String$(2 ^ 15 - 1, "a")

Good afternoon --
I have a template workbook that I want to release to a lot of users.  Much
of the template is protected, but I want to add an unprotected page that has
a pivot table, based on a large table on a protected page.

I currently have (script below) macro which adds a record (from "CashEntry"
sheet, cells $C$2:$P$3) to the bottom of a list (on another sheet
""CashTransferRecord") .
My Request: I would now like the ability to add the record to one of four

I want to copy data from one sheet to another. I have to select Col A and  
as many rows that have data in it (from A1 to A32), but this has to be
dynamic becuase the rows might change. I then have to copy these selected
cells to sheet 1. I nedd the code for this. I knw the ...

It is my understanding that Excel will not Justify if the range has equations
in it - True?  
Assuming that my previous statement is true I was going to have a helper
column in "A" and have my output in "L" and then put in the following logic

I just had some really great help with some Excel files from this group where
the formatting was done by various people over the last 15-20 years.  These
are names for genealogy, and I am loading many Excel files into Access so
people can search by name and soundex.  I don't know ...

Say I have a chessboard (8x8=64 tiles, of course) and e.g. 22 pieces; tiles
are numbered 1 through 64); I want to deploy these 22 pieces throughout the
chessboard (black or white tiles don't matter); every time I do this I get a
set of 22 numbers (numbers of the tiles the pieces ...

Does anyone know how to pass/call a global variable between two workbooks?
Both workbooks have a Global variable declared in module1 called wkName. Any
thoughts?
Set wbResults2 = ActiveWorkbook

I'm using autofilter to collapse and expand a range based on value of Criteria1
I would like to use code to be able to alternate between Criteria1:="1" and
Criteria1:="All"
This is the code that i thought would work but hasn't -

I have date data entered in a cell as general format like 24/12/07 (in
general format left side aligned)
I have to change this date to date format. How to change this through macro?

I hope someone could help me this time, too.
I need to find the last used cell (that is, not empty, contains some data)
in a Row and to get the column number, witch contains that cell.
E.G. such rows

This code below will rename the Active Page on my multipage.  But it doesn't
stay named.  The next time I use the form, it's lost it's name.  I've done
this similar thing for labels, and their caption will stick, why wn't this?
Private Sub cmRename_Click()