Hello,
I have any issue after running the code to SUM(A1:A10) then place the numberical results
in A12. Then also I have SUM(B1:B10) incell B12; SUM(C1:C10) in cell C12.
The numbers came out at right alignment and no indent. I like to correct the indent
using VBA instead of changing manually. The try the below code, it seems do not work.
Is this a correct vode?
Please advise.
Please Login or Register to view this content.
Thanks
Last edited by Rocky2013; 08-21-2013 at 08:31 PM.
This will indent each of your summations (A12, B12, C12, etc.) extending right from A12 assuming no blanks.
Please Login or Register to view this content.
Perhaps it was the Noid who should have avoided me...
If you are satisfied with my solution click the small star icon on the left. Thanks
1. Make a copy of your workbook and run the following code on your copy (just in case)
2. With excel open, press ALT+F11 to open the Visual Basic Editor (VBE). From the "Insert" menu, select "Module".
3. Paste the code from above into the empty white space. Close the VBE.
4. From the developer tab, choose "Macros", select the Sub Name, and click "Run".
Hi,
It works!! Thanks for the work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks