hi! i have any array with numbers and i want to get the second biggest number
in the array. how can i do this?

I have around 10 worksheets .....5 contains the word "[Trend]" in their
sheet name for example "Product1 [Trend]"
I want a Macro that can search for word "[Trend]" in available worksheets
and delete this word or replace it with some other text..so that worksheet

Hi! I have a udf that reads the contents of a certain nnumber of cells. If
the contents in these cells match the contents of any position in any of two
arrays defined by me in my code then contents of that cell is valid and can
be processed further.

Would like some advice on how to write a macro to do the actions
below:
I will create 12 worksheets for each month containing 2 groups of
items at the starting

I have a table with hundreds of rows and in each of them I need to
search if a specified column has one or more specific words. An
example will ease the explanation:
Excel table

Morning all,
Was wondering if anyone has a way to do the following...
From a submission form, data is transferred to a destination data table, set
up also in Excel. Should the data table currently be open by another user,

hi! I have to use very many if ...end if in my code. to save some space I
want to use if with or (i know this works but i have forgotten the code). Eg
If A(i) = "AAA" Then
           A(i) = 1

how can I evaluate which Form is the topmost??
ChFa

I have a bit of code e.g.
Dim wk As Workbook
Set wk = ActiveWorkbook
Dim sht As Worksheet

An array is created in a sub, call it TestAy
it's passed to a call. What is the technical difference between A and B?
call SubA(TestAy)   ' no parens follow
call SubB(TestAy())  ' parens follow

VBA rookie here.
How can I get the "last modified date & time" from this file in
"C:\Warehouse\FSAPROD13\fsaprod13.txt" ?

i have a worksheet that details the sales to customers. From a userform i
need a command button to open a form that asks for start and finish dates.
These dates need to be used to show all the sales made in this period and be
displayed on a new worksheet

Folks,
I need to accomplish a very simple thing.  When I load a workbook from a
directory, I need to know the directory that the workbook was loaded from
and change the current directory to that directory.  Most of the time the

I was wondering if it is possible in a Userform textbox with Multi-Line to
automaticaly inser " *     " on every line of just to inser that where ever
the user clicked within the textbox and ran the specific macro.  
Ben Z.

I need to get excel to round a number to one of the following number those
numbers are
32
37