hi, thanks for the message. since i am an amateur to programming, i did
not understand the above. where do i put this code, in Excel or in
html. Please advice.

what if the table is on an email message (*.msg) file??? which it
is.....i am sorry....

I want to use the GetfromClipboard method in excel which is not working
properly.

otherwise i have to select & copy contents of table to an excel sheet.
theyget pasted in a column, then i have to select the column & run the
PasteSpecial option, to transpose values horizontally. Its a waste of
time!!

Please help me why its not working?

Rgds,

Sifar