With Statement

**kate.middleton1** · 09-22-2012, 04:21 AM

Hello Everybody,
I have changed the code which is attached with this thread, but it does not works, but the original code works. Can somebody resolve this issue.

**kate.middleton1** · 09-22-2012, 04:37 AM

I have manage this thread to find the answer.

**patel45** · 09-22-2012, 05:07 AM

if you use With you have to put . before methods or properties like

Please Login or Register  to view this content.

otherwise you can use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

**kate.middleton1** · 09-22-2012, 05:45 AM

Hello Patel45
Yes you are right, later on i realized that i made a mistake thanks for help.
Actually now the problem is that the columns remain changing so i set the header can you please see the attached workbook and tell me how to make the changing.

**patel45** · 09-22-2012, 08:28 AM

Please Login or Register  to view this content.

**HaHoBe** · 09-22-2012, 09:02 AM

Hi, Kate,

Forum Rule #8:

8. Don't cross-post without a link. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post. Expect cross-posts without a link to be closed.

Be so polite as to provide the link (both here and at Mr. Excel).

Ciao,
Holger