Can anybody help a beginner in scripting with this, please:
Working in 1-2-3, and using LotusScript, I want to script a loop that
puts the contents of one cell into another, changing on each iteration
to the next cell in the column. Like this:
[A:A1].Select
For i = 1 To 10
..Selection.Contents = [A:A(row number)].CellValue
Next
where (row number) can be given as i + 28.
But I don't know how to express that properly.
--
TSH
For email, replace 'SpamOnlyToHere' with my initials
LPG info. page: www.tshargrave.co.uk
Now with added Biodiesel (and getting a bit out of date)
.
Re: Nine random and unlike numbers ...Sub randNumber()... This puts a random number in cell A1 then starts a loop from A2 which first ... And then so on in the loop with the next cell.... (microsoft.public.excel.programming)
Re: Nine random and unlike numbers ...Sub randNumber()... This puts a random number in cell A1 then starts a loop from A2 which first ... And then so on in the loop with the next cell.... (microsoft.public.excel.programming)
Re: How to make Internet Explorer window top most? ... > How to place Internet Explorer on top(modal window).... You could set a title, and use AppActivate on it, an example here: ... You should add an "WScript.Sleep 100 in this loop to avoid CPU hogging. ... -- torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway Administration scripting examples and an ONLINE version of the 1328 page Scripting Guide: ... (microsoft.public.windows.server.scripting)
Re: readLine method help ... When I use your code without the if loop, it writes localhost into the document... ...dim fso, fl, count ... torgeir, Microsoft MVP Scripting and WMI, Porsgrunn Norway Administration scripting examples and an ONLINE version of the 1328 page Scripting Guide: ... (microsoft.public.scripting.vbscript)
Re: Sleep until any keystroke ... SAPIEN Technologies - Scripting, Simplified.www.SAPIEN.com ... VBScript & Windows PowerShell Training -www.ScriptingTraining.com/classes.asp ... Within the loop, insert the Do While stdin example. ... I think by design that ReadLine for STDIN will sit and wait forever. ... (microsoft.public.scripting.vbscript)
