I have a range that i have set as myrng
this range is A1:a100, in this range i have either a "n" or a "y" in
each cell,  how can i use code to count all the y's within this range
john

I am trying to improve my macro.
At the moment I have data in column A. It always starts in cell A1 and I
need to find the last row with data. At the moment I have the following code:
Cells(1, 1).Select

I have two arrays that are 3D.  Each dimension is populated within Three tier
For Next loop.   The first array has data, the second array has dates
associated with its companion element in the first array:
DataArray1(0,0,0) and DateArray2(0,0,0) are related.

Recently I've been working on two relatively large Excel applications, and
both have given me grief in terms of odd behavior from Excel. After a lot of
fooling around and awkward workarounds, I'm nearly convinced that I'm
basically bumping into Excel bugs.

I have a hyperlink on one cell that activates another worksheet. I'd like to
do the following:
By pressing that hyperlink I want to autorun a macro that will do some
changes in second worksheet.

i created an add-In which provides a menu with sub menu-entries
menuMain
   submenu   CTRL+ALT+L
problem: The menu shortcut does not run. nothing happens.

Is it possible to erase specific dimensions of an array while a routine is
running to increase the performance of the routine?  Lets say I have a 3D
Array:
Redim 3DArray (0 to 10000, 0 to 300, 0 to 50)

I want to check if any workbooks starting with "Data" are open.  e.g.
Data_document.xls or Data_gathering.xls.   How can I check for open
workbooks using wildcards?

In my code, when I open up a new workbook which has a userform splash
screen, the unload userform1 code works tos top it loading up.
However, later on in the coding where I activate to a different
workbook, the unload userform1 doesn't stop the userform from

Daer all,
Could you please help me with following:
I need excel macro for my problem.
I want macro which will auto run when I press the hyperlink in one cell.

I am calculating dates in a loop and using the following date format:
DateFormat = "dd/mm/yyyy h:mm"
When I print to the Immediate Window, the first hour (hour ending 0) shows
up without the h:mm extension. I expected to see: 01/01/2005 00:00:00.

Thanks for reading this. I'm new to macros, so be gentle with me!
I posted this in excel.misc a couple of hours ago without a response so I am
trying here. Sorry, but I should have cross-posted.
Help!

i want to check code no(eg. 1,2,3,4,5) in a particular cell and for related
code match i want to display a contents from other cell
Please suggest

I have been playing around with running a macro before a sheet is closed, and
I have found it very useful.
I don't know if this is possible of not, so I would apreciate your advice,
when a user attempts to close the workbook, I want my macro to run a check,

ComboBox1 ListFillRange is Range1 and linked cell is Combo1Code
ComboBox2 ListFillRange is [Range2] where [Range2] must be a subset of the
whole Range2, where FieldA is equal to Combo1Code
Is there a way to filter this Range2 on the fly (in memory) and therefore