VBA Macros to Trim

[hecgroups]

Hello Again,

I am looking for a VBA Macros to trim only first row (Header) i.e. Range("1:1") but uptill last available data column.

Any help on this problem.

[NeedForExcel]

Hey!!

Use this code -

Please Login or Register  to view this content.

Thank You,

Deep

[hecgroups]

Thanks for your code topic marked as solved and reputation is added.

[MarvinP]

Hey Deep!!

The "Dim LC as Byte" scares me a little.

Byte can go from 0 to 255. If the OP had more columns that 255 your code would break!!

In Excel 2003 the max columns was 256 - see http://office.microsoft.com/en-us/ex...005199291.aspx
But in 2007 they increased it.. See: http://office.microsoft.com/en-us/ex...010073849.aspx