I have created a marcro and set it for 'All open Workbooks'.
When I open another xls-file on the same computer the macro is not visible
in the list.
What should I do to create a marcro that is usable for all workbooks on my

The typical way to accomplish the above diseminated in these newsgroups
has been
myArray2 = Application.Transpose(Application.Transpose(myArray1))
Less typical, but equally effective, is

Can someone let me know if it is possible to get the row index number to
change in relation to the row that the formula is copied into when using the
fill handle. Here is an example of what I am trying to do.
=IF(ISERROR(HLOOKUP($C$1,Data!A:Z,7,FALSE)),"",(HLOOKUP($C$1,Data!A:Z,7 ...

I trying to create a code the will validate my data in a range of
cells:
B5:D5 is a merged cell
And

I got a Workbook Test.xls
in cell B2 i have a hyperlink to G:\Temp\Temp2
When i click on that link, the map with files popup
Then rightclick on file Test2.xls and select send to

Does anyone have any routines available which will allow one to print off
worksheets in a spreadsheet which have entries in them, e.g. worksheets 1,
4, and 5 will have data in whereas 2 and 3 are empty?
Thanks in advance

If the string from the input box is not found, I want to rerun the code if
the retry button is selected from the message box.
How do I fix the code below to make this work?
Sub FindStr_sub()

I'm trying to do the custom ribbon example on pages 736 - 739 of John
Walkenbach's "Excel 2007 Power Programming with VBA".
I haven't been able to get the example files that should have been on
the cd (the cd just has a file that says it wasn't ready). So I'm

The code below copies a worksheet into a new book and then emails the
new workbook. When the original worksheet is copied to a new workbook
how can I modify my code to also copy Module5 to the new workbook?
My Code:

I would like to extract (import) data from web site and for that i
have written query.  I got stuck because in the web site there are
dropdown menus.  I would like to select any one from dropdown menu
e.g. if options in the dropdown are lacs, crores, millions, billions

I am looking for a macro function that will read tab-separted pairs of x-y
data from a text file.  For example, it could be ReadLine(filename,
line_number), which would return a line of text that I can manipulate using
worksheet functions to get the x and y values.  It could, but ...

Is there a way you can show a table (or named range) live in a userform like
can be done in access?  By live I mean changes can be made to the table and
they are saved.
Thanks,

My page numbers in my excel printout are large and opaque. How do I make them
smaller and transparent?

A proprietary spreadsheet my son created for a client of his now blows up on
the client's machine. This is version 46. Excel version is 2000. The previous
45 versions of the spreadsheet have not had this problem. We cannot reproduce
the error on any computer here.

I have the code below which hides empty columns when I autofilter from
column D onwards. The autofilter data sits in column C. All I want is the
Column data to sit in column D and it hide columns from E onwards. What
little thing do I change? Thanks.