Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Trying to figure out a way to push a selected range against the right edge
of the screen by inreasing the width of column A. It thought a loop like this would do it: Do Until lRangeRightCol _ rngVis.Cells(rngVis.Cells(1).Row, _ rngVis.Columns.count).Column Columns(1).ColumnWidth = Columns(1).ColumnWidth + 1 Set rngVis = ActiveWindow.VisibleRange DoEvents Loop Where lRangeRightCol is the right-most column of this range. However it doesn't work. Column A gets wider and wider, but the loop doesn't exit. Updating the screen doesn't help or more precisely doing Application.ScreenUpdating = True doesn't update the screen and maybe that is the trouble. Any suggestions how to do this? RBS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I print edge to edge with absolutely NO margins | Excel Worksheet Functions | |||
Move workseet tabs from the bottom of the screen to the right edge | Excel Discussion (Misc queries) | |||
And once again: X and Y Screen Coordinates of a Range | Excel Programming | |||
X and Y Screen Coordinates of a Range !!! | Excel Programming | |||
Edge Sequence Color | Excel Programming |