Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save OberdanBrito/1a1cdadbac66dd850136d87f39961530 to your computer and use it in GitHub Desktop.
Save OberdanBrito/1a1cdadbac66dd850136d87f39961530 to your computer and use it in GitHub Desktop.
Do
final = final + 1
If InStr(ws.Cells(final, 1).Value, "Empresa:") > 0 Or vazios = 10 Then Exit Do
If IsEmpty(ws.Cells(final, 1)) Then vazios = vazios + 1
Loop
Range("A" & inicio & ":K" & final - 1).Copy
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment