First of all, I'm a relative newbie when it comes to arrays. I tried
to generate a dynamic array , named 'ClusterValues()' . When I point
my mouse over 'Array(TStV4)' it seems(!) to be a valid array 'saying'
"1, 2, 3" , when I test this array using:

I'd like to construct a path name by adding a filename to a directory
path, such that it works whatever platform it's being run on.
ie I need to know what to use as the separator so that it puts in a "\"
on a PC & a ":" on a Mac

I'm trying to write a macro that declares variables in a dim statement where
the number of variables are based on a count (number of cells in a range for
example).  To illustrate I present the following macro :
Sub SetVariableNames()

Please help.  VBA Ignorant.  I am trying to build a macro to convert a lot of
fixed width data from text to columns sequentially for multiple rows.  The
macro recorder will not work due its nature with arrays.  The simple keyboard
commands that do work are as follows:

I need to make a macro that monitors and detects when a new row its added to
a worksheet and calls a fuction.

Loop relative row
Hello
With  the macro macro_C(), I call the macro C_N all the 28 rows.
Select column 17 of each row for puts the result of C_N at it

I have mutlitple boxes on a userform that run the exact same code as
can be seen below.  For the sake of efficiencey I would like all these
textboxes to reference the same section of code, but I can't seem to
get it to work.  Can anyone help me with this problem?

I am trying to write a formula and struggling to get it to work.  The goal is
to grab a specific value (ex. “2”) from two specific columns on a separate
tab.  If a row has that value in either cell then I want to read a formula
from a different cell on that row.  This would be ...

For Example:
Before
               A                B               C                D
1           Button1                       Button2

I have been using RDB's script for summarising a worksheet from
different workbooks to great effect.  I have modified it to suit my
initial needs as below.  However, I was wanting some (a lot) of
assistance to change/modify the "getopenfile" code to be able to read

I am using excel to data log serial data read from COM1, the worksheet its
been filled but I need two things
Table estructure
Date                Time    Event

Can someone point me in the direction, I've seen it while researching
but can't find it again, a web site that has a set-by-step guide to
creating a custom menu in Excel 2007.

Example :
Before :
Part name            Qty           Location (seperated by comma)
Button 1                 2                B1,B2

I am working on a excel staff structure that has an issue with
changing formulas and VB programming. All formula cells are protected
and half are hidden
but every so often a reference will disapear from a formula. It is

I'm populating a spreadsheet from a template using Access VBA.  A cell
in row 3 contains a pulldown static menu of selection items.  I need
to copy these cell menu options to each new row of data copied to the
spreadsheet.