I am setting up a workorder sheet that will be printed and saved.  I would
like the workorders to have numbers automatically - the number in the cell
would increase by 1 each time I opened the master sheet.  Is this a macro, a
button?  I have Excell 2003.

I need to hide a number of columns in a sheet and have used Columns
("C:C").EntireColumn.Hidden = True.   This is fine but I have 15 columns to
hide and having 15 rows of code seems excessive.  Is there a way to declare
the columns and thus apply in less rows of code?

EXCEL 2003
I am filling 2 listboxes.  The first listbox is filled like this:
   lr = LastRow(ThisWorkbook.Worksheets("Mesh"))
   With ThisWorkbook.Worksheets("Mesh")

I found the following code in a post from 2005.  I tried to follow the
instructions.  I pasted the code in the view code and exited back to EXCEL.  
i am trying to allow a user to click column D, E, and F and have EXCEL
automatically insert a check mark.

I wish to extract data from a range that meets certain critera and
place it on another part of my spreadsheet, I am using a simple filter
and copy and paste, was wondering if I could do it with out activated
the sheet, heres what i am using at the mo

I would need to know how to print to a specific printer and then set the
default printer back to the original printer.
Thank you,
QB

Hi All,
Sub RowCol_vCellId(CellId As String, Row As Long, Col As Integer, _
 Optional bShowMsgPrompt As Boolean = False)
  Above is just an example of a continued Sub stmt. During development to

I would like to know if there is a way to create individual spreadsheets from
a master spreadsheet thru a macro.? For example, my master spreadsheet has 10
salesmen listed and I would like to have a spreadsheet for each salesman.
Thanks.

A    B        C    D    E    F
Item    Description       Cost    Tax    C+    Sell
1    Item      15.00    124    123.8    495.0
2    Item               

I would like to enter a formula in column J that refers to a variable range
in column a.  I think I'm going about it in the wrong way.  Everytime you run
the macro, it updates data from an XML file and creates a new worksheet with
today's date. Can you help this beginner?

I'm trying to simply add a selection button next to each of 3 options on a
proposal form.  Each button should toggle between 'selected' and 'not
selected' status.  I want to user to be able to click on the button next to
their preferred option to indicate their choice.  

I am trying to copy the value from one textbox on one worksheet to another
worksheet.  Any suggestions.  Thanks
Linda

I have created a couple macros in Excel 2000.  Opening the spreadsheet
displays the pop up that "C:\blah\blah.xls" contains macros.
Is there a way to permanently enable this macro without decreasing
security for potentially harmful ones?

I have percentages in column A, and values in column B.
The numbers are organised by groups separated by blank cells. I want to be
able to sum clusters in B based on values in A with the following exception
Sum all values Except when there are multiple occurences of 80%, stop at ...

I am guessing that this is incredibly easy, but it is beyond me.  All I want
to do is click the Image box on the UserForm and be able to select a Picture.
I can very easily get the code to write to a desired cell using
xlDialogInsertPicture, which I like because it ensure that it ...