Hi, Is there a way to drop down the menu as soon as the cell is
activated? right now my menus  are through data valadation, if I have
to use another way that will be ok! in the long run, it will pay off...
Dave

Can someone help me with : I need to import the second line of a .txt
file. And the second problem is i only know the first few letter of the
document name. Any tips on how to solve this matter.?

i opend the userform in modaless.
and then i want to activate not the userform but the xl application.

I have a large dataset of global climate data, sourced from copious
meteorological stations throughout the world. However, due to equipment
failure (etc etc), the dataset is not entirely complete. I have a macro
which will interpolate parameter values where there is a value either

How can I transpose the above other than selecting each record individually
and paste special with transpose.  I have thousands of records and would
like to just run a macro to do the job.
thanks!

I have managed to produce my first macro
The only problem is the layout, I wonder if any one has a script for the
following
BATMAN       CAPER            WINGS

Hi Dave
Thanks for your response,
I'm sure that there is nothing wrong with your script but it won't work on my
workbook. Please ignore my first 2 posts. I have now changed my mined and

I am looking for a free downloadable course/tutorial/manual/guide
on VBA for beginners.
I need something which could teach me step by step (with examples)
how to use VBA - first of all with Excel97 or later.

I want a function which will return a range containing all the cells matching
certain criteria: like .find, but returning more than one cell at a time. I
tried this and I get really weird results - sometimes it skips cells,
sometimes it loops forever. Any suggestions?

I'm trying to compare text, but the text is not always exactly the
same.  Sometimes words are rearranged, changed, missing.  So I'd like
to create a function that returns the percentage of words that are
common between the two strings.  Any suggestions?  Also, is there a

Hi;
My range is Column R from row 2 to lastrow - where last row is approx row
5000.
My Formula is:

Task: I need to write a macro that grabs a particular Range and generate
a userform with a combobox.
Description:
Sheet1 contains names in cells D4:D34

Sub Opendefactivewkbk()
  On Error GoTo ErrorTrap1
  ChDrive ActiveWorkbook.Path
ChDir ActiveWorkbook.Path

can someone please tell me how i can create a formula where the total is
always changing
think of the hockey standing, if a team wins they would get 2 points and
their total increases by 2....then they win again so their total increase

I'm trying to develop a way to return a value if a cell or row is a specific
color.  Can anyone let me know if there is a way to write an IF formula that
will accomplish this, or do I need to write VBA code (of which it has been
years since I've remotely played with.)