All I want to do is to make sure every time there is a change in the combobox
all cells are updated, but it doesn't so I tried forcing it byreplacing and
equal sign by an equal sign something like this:
Sub UpdateWkbk()

Hi
My code below clears a cell's value then prompts an error message, if the
input value is outside the specified limit.
But I'd prefer to reverse the sequence (i.e. prompts the error message

I was looking for a faster way to get all the values in a listbox. I have
this code:
Dim vArray As Variant
dim strCSV as String

How do I get all the recipients from .GetItemValue("CopyTo") (0)?
Cliff Edwards

I can't see what is failing in this macro to remove all duplicates.
I always end up with one duplicate left over?
All help is appreciated.
'======

I have a VBA routine that keeps the user updated on progress by changing the
status bar (Processing xxx Row of yyyy).  When the user multi tasks and goes
to do something else and then comes back to Excel the status bar updating is
frozen.  I have the Application.ScreenUpdating ...

i have my 3 workbook opened, runnin the same macro each, with disabled the
calculation of page , and i use Application.calculation for make it
calculating.
but like that it calculates 3 times per cycle each page ..

I created a spreadsheet template that has some VBA code in it, then created
two buttons to call the methods. This way, the person did not have to go to
tools, macros and find the one they needed. But when I emailed the
spreadsheet to the user, they pressed the toolbar button and ...

Hi i liked know more about userforms any peolpe could help me!!!

I've been trying to return an ADO recorset from an Add-In.  Maybe there are
some fundamental reasons why that doesn't work?  I'm new to ADO.
I've gotten it to return, but haven't been able to access the data.  It
tells me that it can't perform that operation when the connection is ...

I have data that is prefilled from other sheets to this master sheet.
The dates are prefilled and a Vlookup applies the data in the appropriate
cell without VB.  I just want to copy and paste special the values in the
sheet for the current date.

I am using the code application.DisplayStatusBar = "xxx" to keep the user
updated on my routines progress.  As long as the user keeps the application
focus on Excel the updating works but if they say, go check email and then
come back when Excel regains focus the status bar does ...

I have a macro that moves a bunch of columns around, formats them, and
inserts a blank column A.  That's the easy part :).
Problem 1:  In column A, I want to collect data from column B using
=RIGHT(B1,3).  I want this to loop through until there is no more data in

Hello From Steved
   Shname = Array("Sick Graph")
To This please
   Shname = Array("Sick Graph","Accident Graph")

I need help to perform this task.
For dt=2 to 1000
If cells(dt,1)=date then Copy paste special this row.
Next dt