VBA to Set the font name, size and alignment

[JJFletcher]

Hello All,

I would like to know if this string can be modified to include Font name, size and alignment?

Please Login or Register  to view this content.

Any thoughts?

Regards,

John

[KOKOSEK]

This should work:

Please Login or Register  to view this content.

[CheeseSandwich]

I created this based on the fact that you look to be changing the formatting of a workbook where the code does not reside, much the same as KOKO's code above:

Please Login or Register  to view this content.

[JJFletcher]

I thank you both KOKOSEK and CheeseSandwich,

Your contribution has had success, Mr Sandwich your solution has produced the desired results... Thanks so much

Regards,

John

[JJFletcher]

Hello Again,

I have an interesting question....

Because this code worked so well, can it also be used to clear the data in the destination Workbook / Worksheet?

Please Login or Register  to view this content.

Your thoughts,

Regards,

John

[CheeseSandwich]

Yes, you was nearly there:

Please Login or Register  to view this content.

[JJFletcher]

Thanks Mr Sandwich,

This cleared the data but indicated an error stating Object Required

Please Login or Register  to view this content.

Trying yours now Mr Sandwich

Regards,

John

[JJFletcher]

Mr Sandwich,

Yours worked perfect - Thanks so much

Regards,

John

[CheeseSandwich]

The best way to look at this is:


wbDest is defined as workbook only (no sheets no ranges)

wsDest is defined as wbDest.Sheets("WorksheetName") - Notice how we have refrenced wbDest, this is now included in wsDest. (again no ranges)

You can now refer to the new workbook by wsDest.Range("A1") as the workbook and worksheet are contained within wsDest


Sorry if my description isnt great, i am not the best at explaining things

Hope this helps

[JJFletcher]

Mr Sandwich,

Thanks so much...

Regards,

John