I would like to use a series of shapes to clear cells on a worksheet. For
example:
Shape1 exists in Cell A1. When clicked, it clears cells B1 and C1
Shape 2 exists in Cell A2. When clicked, it clears cells B2 and C2

i have a list box which dispalys numbers such as 10.87542 how do i format
this so it only has 2 numbers after the decimal e.g. 10.87?
thanks

I have a table with various rows, identified, lets say, by the type o
info (Requirements / Guidelines / Info). I want to program a macro (fo
a button) to hide all rows that contains "Info" in the "type" column.
I do not want to enter the number of the row in the macro, because if

1st the question.  If I use Set rng = ActiveSheet.AutoFilter.Range and
then do this rngColumns = rng.Address I can extract the columns from
here with Instr(Left/Right/Mid) or whatever.  What I want to know how
to do is a for/next to determine which of these columns has its

I have a piece code containing a variable
Dim CopyFullName as Variant
The purpose of the variable is to generate a full file name from a
variety of sources - most of which are string based but some times the

I download a report that has a column heading "Name" and is in column D.  The
name is last name then a comma then a space then the first name, for example
SMITH, FRED.
I would like to write a macro that would generate a report to pull only the

I have a sorting macro that runs on a machine with Excel 2003 but won't run
on Excel 2000.  I used the macro recorder to record the macro but it won't
run on the machine with Excel 2000.   Is there some change I could make to
the sorting routine that would make it compatible with ...

Hi Again,
I need to figure out how I can find a substring within a string in VBA.
Say Col A, Row1 = cats, dogs, pigs
and I want to find cats and if possible know the position in the string.

When I insert a sheet in my workbook, there must be (simple) PrivateSub
added to that Sheet. Can that be done?

I have a set of data that i share with other users and allow them to autosort
through.  The data is protected so that the other users cannot corrupt the
data.
I recently wrote some macros that include detailed multilevel autosorts of

I have a 1-column spreadsheet that contains data in column H (with a heading
in cell H1).  Some rows in column H contain no data or a single space.  
Starting with cell H2, I needed a macro that would examine each cell in
column H and automatically delete a row where no data or ...

Hi Again,
My last post didn't help.
I'm trying to copy (in VBA) all the data in one sheet to another sheet that
is in another workbook.

I am filtering two separate data files by values contained in the column
titled 'City'.  The position of this column in the 1st file is column 10,
however it is in column 9 in the second file.  The filter statement below
works for the 1st file but not the 2nd.  

I need to clear the contents of a certain range and yes I could jus
write the code as follows:  Range("a1:b240").clearcontents
however, the range selection depends on the active cell.  I have trie
entering the following:  Range(activecell

I am feeling rather stupid right now.  I have tried everything I ca
think of, but I cant get this to work.
I have a column that has about 15000 rows of tax id's.  I want t
autofilter this row.  but, autofilter has a max of 1000 entries.  I