VB bug

L

Luc

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)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

loop until empty row and column problem (format cells until the lastrow and column in a report) 4
Pausing VBA execution to allow for full recalculation 1
Duplicate declaration in scope 2
Error 2042 problem with vlookup 0
Passing variables in macros 2
Help with formula in vb coding 5
Returning vars to calling sub 4
Returning values to calling sub 0

Top