I'm not new to Excell but I have never used VBA to create and run a macro. I
am trying to create a macro to perform various functions in a workbook when a
cell is clicked on.
I am working with an inventory workbook and I want to move values from one

I'm having a tough time getting all the values out of an array and into
an excel range.  When I try to do it I only get the first value in the
array in all the cells in the range.  Instead I want each element.
Here's the code:

I've place a command button on Sheet1.  In the click event I call a user
defined public function which I created in the ThisWorkbook module called
Init.  When I click on the command button, I get an error:  "Sub or Function
not defined."

Thought I had this figured out, but I am scratching my head...
I have three columns that have a mixture of information in them, and I need
to offset certain types of information.  The issue I am dealing with is that
sometimes my 2nd column contains quantity, sometimes contains ...

This code works fine. Is there a way to keep it from repeating over the next
5 days. Once Enter is selected I don't want to be asked again untill the next
year. Thanks in advance!

I need some help in replacing carriage returns that is occuring in the
excel file using vbscript.
Anyone to guide me?
Thanks

All the the code works except I need the new sheets to be copied from
the sheet named template. Here is the code.
Sub add_sheets()
Dim wks As Worksheet

Is it correct to say that the CY Currency type within the XLOPER (and not
the double type) is the best option to use when complete accuracy is required
to 4 decimal places? As I understand it, the Currency type offers the
advantage of precise integer mathematics versus the ...

I have a sheet that once cell "A" is blank, I want that row
and all the rows forward to be deleted.  How can this be done?
Thanks,
Me

I am creating a spreadsheet to record and manage IT faults under the
following column headings.
TIME   DATE       Fault Description             Reported By        Reported
To      Result

I have an excel spreadsheet that is getting bigger as I develop it.
It talks over the lan to a piece of electronic gear, gets measurments, and
grabs a screen shot (.bmp) of the equipment LCD screen.
In one worksheet, I am going for my third set of data and screenshot when

Can someone please help me? I want to change the position where the drop down
list marker appears.  It appears on the bottom right corner of a cell and I
want to move it to the left size.  Thanks.

Hello,
Does anyone know how to update a validation list just by typing a new value
into the cell with the list. Inotherwords, if I have a validation list in
cell (a) that has apples, oranges and pears, if I type in bananas, I want

In a previous post Don Guillett helped me and provided the following code.  I
need to change this macro, but don't have a clue how.  Hoping you can help.
Sub fillinblanksN()
lr = Cells(Rows.Count, "c").End(xlUp).Row

I have a large spreadsheet, with alot of VB data validation (under a
Worksheet_SelectionChange sub) and hiding/unhiding of rows (under a
Worksheet_Change sub) based upon user input.  Whenever a cell entry is made,
the screen flickers alot, as if it is going through too much code ...