Combining all With. that connected to same cells

[DavidRoger]

Hi,

I'm wondering if the below code can be put together for better coding. My code is getting longer.

From:

Please Login or Register  to view this content.

To something like:

Please Login or Register  to view this content.

[GC Excel]

Hi,
Try this :

Please Login or Register  to view this content.

[DavidRoger]

Hi,
Try this :

Please Login or Register  to view this content.

Does loop works in Sheet1 (a)?

[GC Excel]

Yes, it should..
But impossible to say for sure without seeing the rest of the code.

[DavidRoger]

It's good. Thanks.

Still want to hear other alternative. Please keep the opinion sending in.

[DavidRoger]

Yes, it should..
But impossible to say for sure without seeing the rest of the code.

I have For i = 1A to 4A but got error. One way is to change my code from 1A-4A to 4-8. Is it possible to replace the For part with something else?

[GC Excel]

You could try :

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[DavidRoger]

You could try :

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Can this line (For i = 4 To 8) be changed so I can put 1A to 4A?

[GC Excel]

Can this line (For i = 4 To 8) be changed so I can put 1A to 4A?

No, you can't.
It like a counter, only numerical values are accepted (1, 2, 3, 4, 5, etc...). That's why you need to combine this variable (i) with a letter after

Please Login or Register  to view this content.

[quekbc]

Are you trying to adjust ALL charts? or just specific charts to 1A-4A and 5-8?

[humdingaling]

Loop for every chart on Activesheet
put a IF statement in there if you want specific chart names

Please Login or Register  to view this content.

[DavidRoger]

Are you trying to adjust ALL charts? or just specific charts to 1A-4A and 5-8?

There are two set of chart, Chart 1-4 and Chart 1A-4A

[DavidRoger]

Please Login or Register  to view this content.

Not working. Chart 1A-4A change to different size and no response to cell when change.

[DavidRoger]

Loop for every chart on Activesheet
put a IF statement in there if you want specific chart names

Please Login or Register  to view this content.

Will you show me?

[DavidRoger]

Not working. Chart 1A-4A change to different size and no response to cell when change.

After checking, I found that I didn't replace D100 to D101.
It working now. Thanks.