LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default I found these text strings printed out. What would they do if used in VBA?

I found these text strings printed out. What would they do if used in
VBA?

What would these do? I found these printed out somewhere.

ActiveWindow.LargeScroll Down:=1
ActiveCell.Offset(13,0).Range("A1").Select
ActiveWindow.LargeScroll Down:=1
ActiveCell.Offset(13,0).Range("A1")Select
ActiveWindow.LargeScroll Down:=1
ActiveCell.Offset(13,0).Range("A1").Select
ActiveWindow.LargeScroll Down:=-1
ActiveCell.Offset(-13,0).Range("A1").Select
ActiveWindow.LargeScroll Down:=-1

ActiveWindow.ScrollRow = 353
ActiveWindow.ScrollRow = 239
ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 9
ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 9
Selection.EntireRow.Insert
End Sub
Sub Macro20()

ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 239
ActiveWindow.ScrollRow = 353
ActiveWindow.ScrollRow = 468
ActiveWindow.ScrollRow = 583
ActiveWindow.ScrollRow = 468
ActiveWindow.ScrollRow = 353
ActiveWindow.ScrollRow = 239
ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 9
ActiveWindow.ScrollRow = 124
ActiveWindow.ScrollRow = 239
ActiveWindow.ScrollRow = 353
ActiveWindow.ScrollRow = 468
ActiveWindow.ScrollRow = 583
ActiveWindow.ScrollRow = 698
ActiveWindow.ScrollRow = 812
ActiveWindow.ScrollRow = 927
ActiveWindow.ScrollRow = 1042
ActiveWindow.ScrollRow = 1157
ActiveWindow.ScrollRow = 698
ActiveWindow.ScrollRow = 812
ActiveWindow.ScrollRow = 927
ActiveWindow.ScrollRow = 1042
ActiveWindow.ScrollRow = 1157
ActiveWindow.ScrollRow = 1272
ActiveWindow.ScrollRow = 1386
ActiveWindow.ScrollRow = 1501
ActiveWindow.ScrollRow = 1616
ActiveWindow.ScrollRow = 1731
ActiveWindow.ScrollRow = 1845
ActiveWindow.ScrollRow = 1960
ActiveWindow.ScrollRow = 2075
ActiveWindow.ScrollRow = 1960
ActiveWindow.ScrollRow = 1845
ActiveWindow.ScrollRow = 1616


Selection.EntireRow.Insert

Application.Run_ "Reordering things
appropriately.xls'!zzzzzzzzzzzzzzzzzzzzYmiranother recursivityanotherrecursivity"
Application.Run_"Reordering things
appropriately.xls'!zzzzzzzzzzYmiranotherrecursivit yrecursivity"

End Sub

Cells.Find(What:="Ymir", After=ActiveCell, LookIn:=x1Formulas,
LookAt_:x1Part, SearchOrder:=x1ByRows, SearchDirection:=x1Next,
MatchCase:=_False, SearchFormat:=False).Activate
ActiveCell.Offset(0,1).Range("A1").Select
ActiveCell.FormulaR1C1="=SUM(R[-400]C[-3]:RC[-3])'
ActiveCell.Offset(1,0).Range("A1").Select
Cells.Find(What:="Ymir", After=ActiveCell, LookIn:=x1Formulas,
LookAt_:x1Part, SearchOrder:=x1ByRows, SearchDirection:=x1Next,
MatchCase:=_False, SearchFormat:=False).Activate
ActiveCell.Offset(0,1).Range("A1").Select
ActiveCell.FormulaR1C1="=SUM(R[-400]C[-3]:RC[-3])"
ActiveCell.Offset(1,0).Range("A1").Select
End Sub

Application.Run_
"Reordering things
appropriately.xls'!Findymirandaddthe400precedingro ws"
ActiveWorkbook.Save

ActiveWorkbook.Save
ActiveWorkbook.SaveApplication.Run

Selection.EntireRow.Insert

ActiveCell.Offset(-1,1).Range("A1).Select
ActiveCell.FormulaR1C1 ="=SUM(R[-47]C[-1]:RC[-1])"
ActiveCell.Select
ActiveCell.FormulaR1C1 = "=SUM(R[-47]C[-3]:RC[-3])"
ActiveWindow.SmallScroll Down:=-176

ActiveWindow.ScrollRow = 132

Application.Run"Book2.xls!findymir"

Selection.EntireRow.Insert

Cells.Find(What:="Ymir", After:=ActiveCell, LookIn:=xlFormulas,
LookAt_xlPart, SearchOrder:=xlByRows, SearchDirection=xlNext,
MatchCase=_False, SearchFormat:=False).Activate

Selection.EntireRow.Insert
Cells.Find(What="Ymir", After=ActiveCell, Lookin:=xlFormulas,
LookAt_=x1Part, SearchOrder:=x1ByRows, SearchDirection:=xlNext,
MatchCase:=_False, SearchFormat=False).Activate

Application.Run "AVERAGE COST OF STOCK FOR 2005.xls'!findymir"

Selection.EntireRow.Insert

ActiveWindow.SmallScroll Down:=11
ActiveWindow.SmallScroll Down=-6

Range("G51114:G560000").Select

ActiveCell.Offset(1,)).Range("A1").Select

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to show date printed, updated only when worksheet printed? Sam Excel Discussion (Misc queries) 4 April 4th 23 10:49 AM
find and replace numeric strings in larger text strings Mr Molio Excel Worksheet Functions 8 November 9th 11 05:17 PM
text is getting cut off when printed due to row ht. bkikoen Excel Discussion (Misc queries) 1 November 18th 09 07:37 PM
Printed 5 documents via Microsoft Office Doc Image Writer - and they are nowhere to be found - and it's freaking me out?????????? JethroUK© New Users to Excel 12 December 1st 08 02:58 AM
text visable but do not want printed tazmania Excel Discussion (Misc queries) 1 February 17th 06 03:40 PM


All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"