Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
VB bug
0 views
Skip to first unread message
Luc
Nov 10, 2009, 2:47:02 AM11/10/09
to
This macro worked until now.
Now the following code is skipped.(ActiveCell.Offset(1, 0).Select)
'endzone address = $E$100
'activecell.address = $E$10
'activecell.value = "" (empty)
Now the following code is skipped.(ActiveCell.Offset(1, 0).Select)
'endzone address = $E$100
'activecell.address = $E$10
'activecell.value = "" (empty)
activecell.offset (2,0).select
Do Until ActiveCell.Value <> "" Or ActiveCell.Address >=
Range(EndZone).Address
ActiveCell.Offset(1, 0).Select
Loop
activecell.offset (3,0).select
--
Luc
0 new messages