Hi,
i never found a website of Masters except Mr excel on the internet, any problem which i faced, got solved here by the expert members of this forum realy thanx.
and this time the questions is about a code which i also got in this forum by respectable "wrightyrx7".
the code:
Sub Count()
With ActiveSheet.Range("A1")
.Value = .Value + 1
If .Value >= 10 Then Exit Sub 'limit
End With
Application.OnTime Now + TimeValue("00:00:02"), "Count" 'every 2 seconds
End Sub
generates increasing numbers till the last given limit.
and now
may i have a piece of code to add into this one, by which the sheet get printed after every increase.
for example
A1= 1 =print
A1= 2 = print
and so on
i never found a website of Masters except Mr excel on the internet, any problem which i faced, got solved here by the expert members of this forum realy thanx.
and this time the questions is about a code which i also got in this forum by respectable "wrightyrx7".
the code:
Sub Count()
With ActiveSheet.Range("A1")
.Value = .Value + 1
If .Value >= 10 Then Exit Sub 'limit
End With
Application.OnTime Now + TimeValue("00:00:02"), "Count" 'every 2 seconds
End Sub
generates increasing numbers till the last given limit.
and now
may i have a piece of code to add into this one, by which the sheet get printed after every increase.
for example
A1= 1 =print
A1= 2 = print
and so on
