I collect a variable column from a messge box:
st = InputBox("Insert column to start")
and I then want to get the value for a range of cells in this column and
subsequent work on them, all in a loop (where lastrow has been determined

I have an Excel spreadsheet that saves in two different formats when you
click save.  One is as a webpage the other is just as Excel.  How do I remove
the saving as a webpage?  Thanks.

I have a spreadsheet with data in colum A:D rows 5:24
Lets say they're items in a list.  sometimes the list has more itmes than
others.
Description       Cash IN    Cash Out     Running Balance

We use IBM Lotus Sametime connect 7.0 chat software to communicate
with all the employees in the office. Can I send autmated messages
through that chat window from Excel using AppActivate and Sendkeys?
If yes, how?

I'd like to delete macro buttons in my worksheet, but not necessarily other
shapes like pictures.  any way to do this?  thanks...

I'd like to be able to place my cursor in a cell and run a macro that selects
that cell, plus 2 additional cells to the right (in the same row) and move
all three cells up one row. (basically a  cut and paste).
Easily possible???

I want to hide other rows that Do NOT have aconditional format..  We have a
VLOOKUP driving the conditional formating.  It turns the cells RED.  I want
to examine the cells in the rows and hide the rows that do not have the
conditionalformat changed to RED.

I wrote a function that returns the value to the cell in which it is
executed and modifies adjacent cell, but apparently you couldn't do that as
functions aren't allowed to READ or MODIFY contents of other cells?
So I have to write a sub procedure it seems. My question to you is, ...

I have a worksheet with 40 columns.
This is part of the worksheet:
--                 A
B                                     C

I would like to open a DBF file in XL. In this file, I have some Date fields
in format "AAAMMDD" (ex: 20070215 for today). In XL 97 or 2003, when I open
this file, the date fields are recognize and in the cell the date is in
format (DD/MM/AAAA as it is a french system). But in ...

x = ActiveCell.Column
Returns 1 for column A
How do I get x = A?
Hmmm

I found this macro in the forums and it works great.  What is does is
create a seperate CSV file for every row in the workbook.
What I would like to do though is create a file for every 25 rows.  I
also would like to make the files .XLS, not .CSV.

I am so new I squeek
I need to put shapes/ autoshapes and small photos in a cell.  Like cell( B:2)
How does one control the autoshape or photo properites using VBA?

In column B I have a linking formula to a specific file.  In column A I have
about 200 rows with different file names in each row. I would like to replace
the file name in the linking formula in column B with the file name in Column
A so that then the resulting linking formula in ...

Right now my macro is creating a new worksheet for each name in a range.  
However, i want my macro to create only a new worksheet for each VISIBLE name
in a range because I filter this list.  Please help!!!!
Sub name_sheets()