I have different VBA procedures in different workbooks and I need to call a
procedure from one workbook to another. How can I do this? How is the right
syntaxis?
I appreciate any help.

Hi guys I would like to know  how to sustitute the "Columns(4).Rows.Count"
statement for something more efficient, the Idea is to know in wich cell I
find the last record, instead off read all the column , there are no empty
cells in between, I had to assign Long to "i" because I ...

Is there a way to unhide all sheets in excel without using vba other than one
at a time?

This version does work better. Now it is counting on the columns and I can
see it in the msgbox.  Before I think it wasn't counting any columns. It
still doesn't hide any columns though.  The reason is there are blank's in
the data rows because there are subtotal rows on groups ...

I am trying to figure out how to clean up a workbook automatically. I
have a workbook that has a name and location in the first line. Three
to four rows down I have several columns that have a cost analysis in
them. Problem is I have a  1000 names with cost analysis and I want to

I am trying to memorize the values and addresses in a selected range.  Does
anyone know the syntax for going to the next selected cell?  I thought
something like selection.next.activate would work, but that just goes to the
next cell regardless if it is selected or not.

I know I can use ActiveSheet.DrawingObjects.Delete to delete all drawing
objects on a sheet.
Is there a way to select all drawing objects EXCEPT for charts and text
boxes (or anything else for that matter)?

Something is wrong with the OR statement on the line with the asterisks.  I
want to hide the columns that have all n/a's as the only data cells.  There
could be some blanks also but otherwise no data.  Also, I was trying to debug
it and see what column it was counting.  I can't ...

In the event that a subroutine becomes obsolete due to changes in the
spreadsheet data, can the sub be deleted/erased automatically as another sub
detects the reasons for the obsolescence?
If anyone has insight into this, much thanks.

Hi just wondering if cell location with a specific string can be located with
a macro!  thanks

I am trying to use an activeX button to link to select a specific cell
within another sheet within the same workbook. That is, with the
Command button in Worksheet1, I want users to click it and be linked
to Cell B40 in Worksheet5.

I found this code in another thread and edited it for the range. The
code works fine if nothing is in the cell. But in my cells there is a
formula. The results of these formulas (value of a cell on another
sheet). Sometime these values era simply nothing, but the code doesn't

set a wrksheet to add time and date when a number is entered in an adjacent
cell, have 40 rows similar, but when i move to next line it recalulates the
times in all lines. How do I stop it from recalculating in all cells?

I am looking to create a new array with elements of  a previously
created array. Where:
For Each cell In Ratings
       ReDim Preserve Ratings1(6, rw)

I have an Excel Solution that I am nearing completion. I've recently noticed
that if I open my workbook using Excel 2000, my protection is rendered
useless. I'm using a protection that is activated upon opening up the
workbook. It appears that Excel 2000 is not engaging this ...