Hi All,
Hope you all are good.
I need a VBA procedure which will align all the text in Left and all the numeric in center in a given range.
Thanks in advance.
Hi All,
Hope you all are good.
I need a VBA procedure which will align all the text in Left and all the numeric in center in a given range.
Thanks in advance.
Modify as needed
Code:ActiveSheet.UsedRange.SpecialCells(2, 2).HorizontalAlignment = xlLeft ActiveSheet.UsedRange.SpecialCells(2, 1).HorizontalAlignment = xlCenter
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
Last edited by DocAElstein; 06-10-2023 at 04:30 PM.
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Thanks for your valuable support it is the same what i want.
Thanks Again.
Posting Permissions
Reply With Quote
Bookmarks