I recorded a macro to see how it works and have the following code (at end).
The problem is that I get the following error:
Invalid or Unqualified Reference - on the With .comment
I had the code working great until I determined I had to Autosize all the

My database is changing everyday (adding and removing of lines)
I've got some pivot tables linked with this database in the same workbook.
I want the VBA code to update the datasource range for my pivot table.
I've wrote this code but I can't understand why it is not the main pivot

I have no desire to do this in VBA. I am using SQL in MSQUERY to retrieve
data from SQL SERVER. It comes in fine, but when I tell it to return data to
Excel, all it does is place the name of the query in the upper left hand
corner of the spreadsheet, whether a new sheet or ...

How do I write a macro to prompt a user for a margin percent number and then
take that number and multiple the actual product cost by that percent markup?
Is there a built-in function for this process already in Excel 2000?
Thanks

I have a worksheet with column B being titles that are indented to
outline the list (I even have the indent level a column).  I would
like to outline this with VBA with a macro, so I can hide and show the
details as necessary.  Can anyone help me with how to set up the loops

I have a userform with a listbox on it.  The list box contains the names of
several sheets in my workbook.  I would like to enable the user to select a
sheet in the list box, and click "Export".  On click, i'd like Excel to copy
the selected Sheet to a new workbook.  The new ...

Hello,
I have been getting my feet wet in Excel VBA Programming. I have run into a
problem. I am tring to have people run a report through a macro. The main
document is on Worksheet1 and I want a user to push a button to have another

I've got a class defined that instantiates itself internally. (It's a
simple binary tree implementation). Are there any OO gurus here can
help me to design the proper class structure so that I can track the
item count (# of nodes in the b-tree) and other statistics that would

I've got a dead simple bit of code where I switch screenupdating on, run a
small section of code (basically runs a routine that puts up a percentage of
progress so the user doesn't stare at a mental screen but still gets some
feedback) and then I try to switch the updating off ...

In order to keep an object in memory with a known reference point, I
typically store it in an element of a public array.  Thus, the element
number it is stored in becomes a reference point to the object and
using this number I can access that specific object's methods through

We have a fairly sophisticated Excel AddIn that generates all sorts of Chart
types.  It works fine in English versions of Excel, but not foreign langauage
versions.
We've narrowed down the problem to when we're assigning the TypeName when we

I am working on a project which I need help.  I have two merged cells:
Two cells (name) contain the user's first and last name.
The next (entry) cell is used for entering data new data.  
I have a fourth cell called comments.

Hi,
I am wondering why I can not find the Yield function in VBA. I type in
"Application.worksheetfunctions." in the VBA workspace to find the yield
function, and YIELDDISC and YIElDMAT is there, but YIELD is not there? Did

how do i make a visual basic function calculate every cycle? I am
constructing a visual basic function in Excell that returns a result using
only clock input, that is NOT DEPENDENT upon cell data.  Normal functions
calculate only when inputs change; There are no inputs; so it ...

I am struggling to pass an array to a class. Basically I defined the
class as follows:
Public xVar As Integer
Public Property Let AddtheStuff(TheStuff() As Integer)