Centered columns in a large pivot table
Three of my columns are set as centered. For whatever reason, some rows (out of 18000) will be right-aligned and it seems to be random.
I did this code.
.... but it is painfully slow and takes minutes.
Please Login or Register to view this content.
What should I look for to improve this?
That code should not take minutes, but it would be better to use something like:
Note that if you have numeric cells with a padded format, like Accounting, then they will appear right-aligned even if the cell is set to centered.Please Login or Register to view this content.
Everyone who confuses correlation and causation ends up dead.
Thank you for the corrected syntax.
Still slow.
If I don't fix it with VBA, here is how it looks (permission denied on image upload). All columns in general format.
https://live.staticflickr.com/65535/...b259dd07_n.jpg
I can't tell anything from a picture.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks