This is the condition I was telling about:
Sub CpySel2Borderou()
'
' ClearBorderou Macro
'
' Keyboard Shortcut: Ctrl+i
'
Range("K2").Select
Do Until IsEmpty(ActiveCell)
If ActiveCell.Text = "TRUE" Then
Application.Run "'MARELE TABEL.xlsm'!Copy2borderou"...
This is the macro that copies the content to the sheet starting with the selected cell, and that is beeing looped until a given condition. This works, but I have to add the autofill to it
Sub Copy2borderou()
'
' Copy2borderou Macro
'
' Keyboard Shortcut: Ctrl+y
'
ActiveCell.Offset(0...
Hi there!
I need to autofill a colum (A) with a series starting from 1, until in the next colum (B) is no data.
It must be a loop until ActiveCell.Offset(0,1) isEmpty
This is the file:
https://www.zeta-uploader.com/301295423
The sheet is "Borderou
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.