Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It is my understanding that Excel will not Justify if the range has equations
in it - True? Assuming that my previous statement is true I was going to have a helper column in "A" and have my output in "L" and then put in the following logic (found after my questions). One item that I discovered was if one line was completely blank it would not "move the text" up. But if I added a " ", the justify would work. Three questions - is there a better way to get around the formula issue? Are there other known issues (other than a blank line) that I should be on the look out for? If there is not a better wary to get around the formula issue - is there better logic than the code below? Sub test() shtCB2D.Range("L35:L39").Value = shtCB2D.Range("A35:A39").Value shtCB2D.Range("L35:U39").Justify End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Where is the justify function in Excel 2007? | Excel Discussion (Misc queries) | |||
How do I use justify across more than 1 cell in Excel 2007 | Excel Worksheet Functions | |||
TOP - Justify and Autofilter the Data in Excel | Excel Programming | |||
Justify matter in Excel - Ajit 160205 | Excel Discussion (Misc queries) | |||
Can I right AND left justify to block text in excel? | Excel Discussion (Misc queries) |