powercell99
Board Regular
- Joined
- May 14, 2014
- Messages
- 75
Morning,
I am trying to write the code to clear all formatting in all columns after the first blank column in the current active worksheet.
Example: Current worksheet has text in columns A:K, but the formatting continues beyond K, and I'd like to clear the formatting in all columns starting in column L. But the next cycle there may only be text in columns A:F, so then I'd like to clear all formatting in all columns starting in column G.
I know xlToRight is involved, but when i use it, it also clears the last column that contains text. Maybe xlToLeft would work??? Hellllppppp please.
Thanks in advance
I am trying to write the code to clear all formatting in all columns after the first blank column in the current active worksheet.
Example: Current worksheet has text in columns A:K, but the formatting continues beyond K, and I'd like to clear the formatting in all columns starting in column L. But the next cycle there may only be text in columns A:F, so then I'd like to clear all formatting in all columns starting in column G.
I know xlToRight is involved, but when i use it, it also clears the last column that contains text. Maybe xlToLeft would work??? Hellllppppp please.
Thanks in advance