Hi,

I need to create a table in Excel 2003 with the following format :

Name Address Age Email
Hari Downtown 30 [email protected]

Can anyone please help me with this? - Thanks!

Justin

Hi

Can you please check ifhttp://vbadud.blogspot.com/2008/07/convert-range-to-listobject-using-excel.html is helpful

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thanks Shasur.. It did help...
I've also got another doubt... Guess I'll open another thread for it..

Regards
Justin

In your example on your Blog Page, What is the reason for the Error Handler line:
I am trying to write and error handler that gives me the Error Code & description. But if there is no error it still goes to handler and gives me an error code 0. I see that you entered this line to prevent that but why is it necessary?

What is err 0?

Err stands for Err.Number, where Err is the error object.

You can write that explicity also if Err.Number <> 0. Whenever there is an error in runtime, this object gets populated.

The most commonly used properties of this object are Number and Description (as the name implies it provides a handy description)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips &amp; Tricks (http://www.vbadud.blogspot.com)