I've got these problems::
a cmdButton on a userform should read 3 text boxes
and assign the data on one row across three columns
but I get it to do things like input into col a row1  then

I have a form whose controls are created and populated at runtime.  I also
have two class modules, each of which handles a change_event for a particular
control.  I received the Runtime Error 91: Variable or With block variable
not set.  Having read several posts supressing ...

let's see if i can explain clearly.
i'm using this to initialize the array
ReDim arr(0 To 1, 0 To 0)
then i use a redim preserve to add the elements

I want to allow the user to type in a list of cost centres and have
the code create an array from that list.  The list may 1 record or it
may be 100.  How do I create a dynamic array?

I am trying to save an Excel file as a web page or publish it and have it
update when the original file is saved.
The web page would be viewed by employees for updated information several
times a day and this would replace a notice board using magnets (archaic).

is it possible to not only declare a public variable, but also set it to a value
to be used throughout he app?

i have date in dd/mm/yyyy format, i need to find the age of the
product but
i think i need to convert the date to mm/dd/yyyy format 1st before
using the formula

XL 2007 only seems to AutoSize the Height of a text box, not the Width.
This is different from XL 95..2003 which autosized both.  (But autosize
for comments (almost) works correctly -- the UI is a bit broken if
editing manually.)

I have a request from a client to do this. (pull numbers from a picture of a
bank check)
AFAIK, it is not possible. Comments.
Also, how do I have a form that can be run by anyone on the web?

I have a VB script in an Excel spreadsheet that imports data from a MS
Project file. Right now I have the Project fields that are being
imported hardcoded in the script, e.g. Name, Text1.
For Each task In MSProj.ActiveProject.Tasks

I am trying to do something I am not sure is possible.  I have a large
Excel file being used as a database.  Multiple users are interested in
accessing this data, but they would prefer to have the spreadsheet
open in the custom view that selects the data of most interest to

Our SQL server boxes don't have M/S Office installed: I'm automating the
download of data to Excel format from a SQL database and would like to use
some VBA to process the workbooks further.  Given I can't use an automation
object without Office installed, does anyone know any ...

I have written the VBA to loop through a column on an Excel spreadsheet and
if the font description is "Script", I want to write the font name, the
alphabet (formatted in the font), and some other detail to a Word Document.  
I have been able to create a new Word document, and I ...

I have data sets like 1-2, 2-3, 3-5, 6-10. I want to extract 1-7 step
interval, this should be (1-2)=1+(2-3)=1+(3-5)=2+(6-7)=1 will be a
total of 5. This way, I have bulk data and want to extract many step
intervals. Any short cut method of macro or good formula will be very

I am trying to do something I am not sure is possible.  I have a large
Excel file being used as a database.  Multiple users are interested in
accessing this data, but they would prefer to have the spreadsheet
open in the custom view that selects the data of most interest to