I can do this in Word with bookmarks. is there a way do this in Excel?

I have a spreadsheet with about ten different tabs.  I am writing a macro
that will print all of these tabs that have data in them.  I can write an if
statement asking if the total doesn't equal 0 then print.  When I do this
each tab is printed out one at a time.  This won't alow ...

Let`s say I have too many worksheet in my workbook.All worsheet
generated by using another userform.In my code i can add item to
listbox.How can I do below code to work for all sheet
Private Sub CommandButton1_Click()

Sub SetReferences()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
     With ws

I need to create a variable sized list of random numbers with a
variable sized range without duplicate values. I have been creating
the list with a variable range with the following code then manually
changing any dup values (checking changes by sorting the list and

What is the correct syntax for including a variable (in this case "i") in
the name of a TextBox and/or Label?
I have a list of TextBoxes and Labels on a userform and I want to program a
reset button to change what is displayed back to the defaults.  I need

First of all, Merry Christmas to everyone
I´ll Try to explain my problem with an example.
I use this simple formula down the column E to solve my problem (TEMPORARILY):
E10 =IF(D10-D$1>=245;"OIL CHANGE";"")

I have a range of numbers in 2 columns; 1st column are the observed values
and the 2nd column are the counts. What I need to do is create ranges for
those 2 columns and count them. The example below show this:
Duration   Freq

i want the user to open an excel workbook of his choice and then
choose a range from that excel workbook.
this, of course, has to happen during the macro run.
and the macro needs to capture the name of the new workbook, the sheet

I need to perform a "Find" search in two sheets and then show the addresses
of the matches in a MsgBox. I'm running XL2000 ( No Potions in the Find
dialogbox)
I think I can create an array with the results and then show each element as

Is there a way to find the last item in a column of numbers and put
that into a different cell at the top of your spreadsheet?
Thanks

I have a certain formatting in my app. I'ld like to preserve it
despite the user tasks of copying and pasting he can perform.
I use Excel 2003 and it gives the ability to select the type of
formatting to apply during a pasting operation:

I am a day trader and need help with template for Name of Company,date of
purchase, # of stocks purchased  $amt. paid  $amt sold  and loss or gain I
know this is probably easy for most people but I can't figure it out.
Thanks

I am trying to figure out a way to check to see if the cells in a column have
6 characters and if it doesn't is there a way I can have zeroes inserted for
the cells that don't contain 6 characters in the designated column.

I found a file on the web today and looked to see what the macro was like to
learn from it.  There is some event code and a tiny in the SS.  When I
deleted all the code, the SS was still automated.  How can an Excel SS be
automated without any apparent macros?