Show Range of Data in messagebox with columnwidth

**naveenmarapaka** · 09-17-2014, 05:29 AM

Hi , My below code is working fine, but it is displaying data in scrambled way...

I want it to be displayed in the same way which shows in excel usually which is auto fit....

at present my result is showing like in attached pic.Capture.JPG

A and F are column names and R1 is Row count number....

Please Login or Register  to view this content.

looking for your help.....

thanks....

**millz** · 09-17-2014, 05:47 AM

I think adding a tab character would be the most ideal though not perfect:

Please Login or Register  to view this content.

**naveenmarapaka** · 09-17-2014, 05:53 AM

Hello millz it's didn't helped to solve..., pls refer 2 attachments before & after......Without Chr 9.JPG With Chr 9.JPG

looking forward for your response....