Thankyou.
-----Original Message-----
Steved

Test1 is Excel VBA code and you can use it anywhere from
within Excel
VBA.

It can be included as part of other Excel VBA code

eg

sub Macro1()
call test1
end sub

It can also be triggered by attaching a button to
activate it

It can also be modified to include the ability to open
other files and
work on those files

All you need to do is pose your query to cover your
specific
requirements and someone will usually reply with a
suitable answer


---
Message posted from http://www.ExcelForum.com/

.