In VBE I have change the properties of name of the
sheetxx (Agent_information)
to
shtAgent (Agent_information)

Is there away to create a macro to put numbers in one row with comma
between them instead having them in 3000 rows?
From
 A

Hi, i am new to VBA, and i created a user form with some radio buttons
and some text boxes. i created some buttons such as next, back and
submit. so my problem is that i want to know if there is a way to
insert the data from the UserForm  into a excel sheet in rows so that

Hello i am trying to record a macro with the recorder but i get a "cannot
record macro" error message.
the formula i am trying to record is (this is the way it looks in excel
mode) :

Could someone point me to a document or explain to me how to have a button
appear in the toolbar or a menu added whenever I select an Add-in? I imagine
that this has to be built into the xla file.
Thak you.

I have a column with multiple numbers in them,
example of one cell 0502,0399
I want to be able to find partial matches like just the 0502.  right now I
have this..

Hi, i am new to VBA, and i created a user form with some radio buttons
and some text boxes. i created some buttons such as next, back and
submit. so my problem is that i want to know if there is a way to
insert the data from the UserForm  into a excel sheet in rows so that

i work with pivot charts quite a bit and am annoyed that they keep returning
to a default format when you change something.  so i was going to make some
code to record the formatting of all series' in a chart, so i can (re-)apply
to a chart.  but before i do, i wondered if ...

Hi, i am new to VBA, and i created a user form with some radio buttons
and some text boxes. i created some buttons such as next, back and
submit. so my problem is that i want to know if there is a way to
insert the data from the UserForm  into a excel sheet in rows so that

I'm trying to automate a method of summing across columns.  To be
exact, let's say I have 5 columns (A B C D E), the first of which
MIGHT contain a negative value (it may also contain a positive value,
and B C D E might have a zero or some positive value.  What I want to

Thanks for taking the time to read my question.
I'm working with a fixed width text file. I want to add x number of spaces
after my value without having to do a loop.  Is there a good way to do this?
I'm using    Print #1, Sheets(SheetName).Cells(RowNum, 1) & "  " &

I am trying to write a short piece of code that loops through a number of
cells in a given row and increments a counter depending on what colour the
interior of the cell is. I am using the following code
   For vC = 10 To 100

I have Office XP with Windows XP Pro.
Is there a tool available or a work around which will allow me to edit -
find/replace words inside of a text box. I have a text box that requires
edit -  find/replace each time the spreadsheet is run. I need this to be

I currently have the following code set up which displays a message box if
the csv I'm importing has greater than 256 fields.  Is there a way to also
check if the csv has greater than 65,536 rows?
fileLocation = Application.GetOpenFilename("ASCII

I know this:
Worksheets("Results").Range("a1:c1").Columns.AutoFit
But I want it for the entire document.... basically I know "c" as a
number, but I dont know the row count.