Hi buddy please use the 'code tags' when posting VBA code samples on the forum. Not only doe this look extreamly cool, but helps with my Administration duties.
Please Read OzGrid Information - Code Tags - jiuk before making any futher postings. Thank you for your understanding.
Note: If your are posting VAB code, please use the 'Code Tag' so anyone helping can easily read and / or copy your code.
Jacks example:
i.e.
Code
sub myName()
' Written by: Jack in the UK
' [url]www.excel-it.com[/url]
' Excel Xp
dim jiuk as string
jiuk = "Jack in the UK"
msgbox jiuk
theEnd:
' jiuk - some code
exit sub
end sub
Display More
Many Thanks
Jack in the UK