I have a named dynamic range for printing, ie AATableA which is defined
as =OFFSET('Table A Master'!$A$1,0,0,'TableA Input'!$B$160,18)
The part of the procedure below prints out only those rows which have
continuous entries and leave all the blank rows below. This works fine

I need to create a macro to print the active page. Can anyone help me with
the codes Please?

I'm trying to code a macro that will be located in a template sheet that I
have, color_template.xls.  What I'm shooting for is a macro that will
automatically copy the color palette in this sheet to every open worksheet.  
It just gets tedious to do a <Tools><Options> "Copy colors ...

How do I assign a toolbar button to a custom number format I created?
Brett

have following Code that I would like to modify. So instead of dividing, I
want to Sum  but can't seem to get the right logic.
'   Dim i as long
   For i = 1 To ActiveSheet.UsedRange.Rows.Count

assuming i have this code, is possible to use this vlookup withnthe adta
into mdb access?...
old scenario:
Private Sub TextBox25_Change()

Hi, if I have 2 instance of excel open, and i want A1 in  workbook1 to
= a1 in workbook 2, what do I put in the cell. Ive tried
=Workbooks("workbook2").Worksheet1.Range("a1"). I want to create a user
form and have the labels in workbook1 = certain cells in workbook2.

this is my first time trying out the ...for..each..next loop
I'm trying to delete the entire row if the cell in the E column contains the
word "USD".  I tried the codes below and get "run time error 424, Object
require" error.  Any help would be very much appreciated.

I have a number of listboxes and comboboxes on an spreadsheet. I fairly
sure you can use ControlTipText to pop up a comment type box using
mousemove event when a control is on a userform, but I can't do this
for those on my spreadsheet. Is there a way of doing this?

I have written a macro that I use a lot and I always use it when I am closing
the document. Is there a way that I can have the macro run automticly when I
close the document?

I am trying to use the if statement to the following pruposes:
if A1 is greater than 13000 but less than 14000 then £25 is entered
into the cell. however:
if A1 is greater than 14000 but less than 15000 then £35 is entered

Have some code that takes a .bmp file and puts the image on a popup menu
item.
This uses LoadPicture and
CommandBarButton.Picture

I am getting a syntax and compile error on the dim cou .... line. Any
suggestions?
Thanks,
Jim

I know this is the subject of many prior threads, but, I'm having
trouble comparing floatinp point numbers.  Values in registers and
values in memory are not exactly equal, even though they were calculated
identically.