I'm trying to set the conditional formats for a whole group of cells, but I
keep getting a error.
Error: Run-time error '5': Invalid procedure call or argument.
I can't understand what is causing the error.  Below is my code, I hope

I have now sorted most of my issues out but seem to have one thing causing a
problem.
I have a form where I select a few checkboxes etc then hit OK.
However, when I hit OK it doesn't disappear. I have used the usual UNLOAD or

I am trying to do the equivalent of this code, but variable:
Rows("546:546").Select
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
(as provided by a Macro)

Hello is it possible to go through a String checking for certain characters?
Basically want to somehow convert a String to a character array and go
through it checking for the ' character. Or failing that, is there a function
that disposes of certain characters within a string.

Another question,
I need to set chart exported to a specific size to fit in
UserForm/ImageControl. Since the chat is large, only small portion of of is
being displayed. I tried other options of changing PictureSizeMode between 0,

morning all.
I've made a macro that will allow me to pick a range of my choosing--
through an input box, and then place it where I want.
The problem that I'm having is that it doesn't like of of my .paste methods.

I'm looking to create a macro with similar function to that of a time clock
used in work shops (one that when activated will copy the current time
(preferably seperated from the date) into another cell for use with other
equations).  It should also fill it in like a list whenever ...

I did write yesterday but with no real success.
I am trying to put a number of values in an array by looping through some
cells.
I'm having difficulty as I don't know how long the array will be nor can I

Value in column A determines values in other cells in the same row.
I want the user to be warned before changing the value in column A
that the contents of the row will be deleted as values in other cells
depend on the value in column A. I am using the worksheet change event

How can I find the x-y coordinates of the upper-left corner of a cell?
I want to insert two overlapping rectangles (msoShapeRectangle) of
different colors into the cell to illustrate the percentage value
displayed in an adjacent cell.  Row heights an column widths on the

I have a file that is stored in a column type fashion, when I transpose the
the worksheet so it will be more database friendly, rows, I end up with
multiple serial numbers in columns to the right rather than down. Example
This is what I have now:

I am been trying to figure this out and I failed.   I am using VS 2008, and
Office 2007.  
I ran a Macro to add a field from SSAS Cube, and I am trying to convert it
to code in C# but I failed.

I have an integer in cell a1. When an integer is input in cell b1, I
need the value in cell a1 multiplied by the value in cell b1 and the
result placed in cell a1. To achieve this I am using the
Worksheet_change event with target range as b1. The program works ok

i seem to remember that there needs to be some line of code addied for this
to occur
thanks in advance,
mark

Hi all, i need to loop through a folder and open all the "xls" files one by
one, get the name from "B1" and then save the file back to the same folder
with the name obtained. Lastley I then need to delete the original file.
Any help with code would be appreciated