ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBscript (https://www.excelbanter.com/excel-programming/311136-vbscript.html)

raji

VBscript
 
Hello,
What does the top =-2 mean in this scipt. I recorded the macro and was using
it for
another sheet, and the macro stopped. When I pressed debug it pointed me to
this line. Did something change in my new sheet, how would I know. Is there a
way to fix that variable ?

Selection.Sort Key1:=Range("D2"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
With ActiveWindow
.Top = -2
.Left = 5.5
End With


All times are GMT +1. The time now is 10:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com