Hi, here is my problem.  I will have data in different cells each time such
as A1:C10, A1:H100, for example. What i need is macro that will insert a dash
(-) under the last line of value in each cell.
For example if there are values in cells A1:C10 I need a dash in each of the

How do I set up a spreadsheet which will select and then add up the best six
arithmetical scores out of 7?  Any help would be appreciated.
The version is Excel 2002 with SP3 running in Windows XP Home version.

i want to show the my icon in left of caption bar on the userform.
how to method?

I've been searching the forum but i cant find a specified help.
I have two xls files, a.xls and b.xls
i want to combine them into c.xls with worksheet a and b
can anyone give me some guide on this?

I have a list of data with a key and its parent key.
It is currently sort by key.
I need to sort by Hierarchy so that the children come after the parent.
Is there a algorithm to do this?

can anybody give me an example??

Through a VB program, I'd like to modify some data for all rows that have
been grouped together using the .group method.
Is there a collection, object, or some other method that I can use to find
the group and traverse through it?

OK, so my add-on hard drive is a tad screwed up - somehow my "My Pictures"
Folder has been converted into a file.
CHKDSK has been so kind(?) as to "recover" these "lost files", and name them
as FILE0001.CHK, etc. in folders called FOUND.000 etc.

I've been working on sending "Get" and then taking the
winhttpreq.ResponseText and searching through it.  Now the problem is I
don't really know the commands to locate what I need.  Basically I want
to search for "Game ID:" and then following gamid is the actual # I'm

My set of data looks like this:
VendorNbr       Amount
1000                $900
                      $750

I've almost got this code the way I need it ,But.The point is not to be asked
again once you've  answered the Userform and MsgBox. The problem is when I'm
at the UserForm and I have a Commandbutton2 thats a "Remind me Later" when
selected closes the Userform with no data but it ...

I have a budget spreadsheet with future pay dates for the next number
of years in row 1 (H1..BA1) across the top.
Down the left in col B (B2..B800) I have "Due Dates",and  in col C
"Amount"

Embrassed to ask again but I've tried everything. The code is finally working
as is the command button but it's not sorting Column "D" I need it to sort
only Column's A,B,C,D
Private Sub CommandButton1_Click()

I have a workbook with a main page and on the page I ahve 7 command buttons
to print specific pages abd 1 command buuton to print all 7 pages.
What I would like to do is contol the printing from a userform.
I have designed a form with 7 checkboxes, a command button to close the ...

I have a work book with a main page that I would like to be the only page the
user sees when they open the book.  This page has command buttons to jump to
the other seven pages. I would like to add some code to the buttons to unhide
the pages and then jump to that page.