 delete all the target rows at once.
Try this:
 Sub AutoFilter_To_DeleteRows()
    With ActiveSheet
        Application.Goto.Cells(1), 1
        Rem Add a temporary header to avoid indiscriminate deletion of the first row.
       .Cells(1).EntireRow.Insert
       .Cells(1).Value2 = "Temporary Header"
        Rem Filter values ending with ";1"
       .Columns(1).AutoFilter Field:=1, Criteria1:="=*;1"
        Rem Delete all resulting rows
       .Columns(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
    End With
    End Sub

 Q:

How to keep internal var in companion object

I have the following class definition:
class SomeObject {

    companion object {
       internal val instance = SomeObject()
    }

}

This class is self sustaining, and is just listening to events.
My problem is that proguard removes the "instance" field.
What do I write in my proguard file to keep the instance field (it can be obfuscated, but i want to keep the field from being deemed as "unused code")

A:

The proguard rule should look like this:
-keepclassmembers class com.your.package.path.SomeObject {
    public static ** Companion;
}

This way you can specify classes of which the companion object should not be removed (including the property). 

 Q:

using oracle sequences with jpa (toplink)

I have a sequence object in my oracle db:
create sequence BASE_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
start with 100
increment by 1
nocache;

I use jpa(toplink) for my web application. I have base class for all my db objects:
@MappedSuperclass
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)

public class AbstractEntity implements Serializable {
    protected BigDecimal id;

    @javax.persistence.Column(name = "ID")
    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "BASE_SEQ")
    @SequenceGenerator(name="BASE_
delete all the target rows at once. 
 Try this: 
  Sub AutoFilter_To_DeleteRows () 
     With ActiveSheet 
         Application. Goto. Cells(1), 1 
         Rem lend a impermanent header to avoid indiscriminate deletion of the beginning row. 
        .Cells(1).EntireRow. Insert 
        .Cells(1).Value2 = " Temporary Header " 
         Rem Filter values end with "; 1 " 
        .Columns(1).AutoFilter Field:=1, Criteria1:="=*;1 " 
         Rem Delete all leave rows 
        .Columns(1).SpecialCells(xlCellTypeVisible).EntireRow. Delete 
     End With 
     End Sub 

  Q: 

 How to keep internal volt-ampere in companion object 

 I have the following class definition: 
 class SomeObject { 

     companion aim { 
        internal val instance = SomeObject () 
     } 

 } 

 This course is self sustaining, and is barely listen to events. 
 My problem is that proguard removes the " example " field. 
 What do I write in my proguard file to keep the instance battlefield (it can be obfuscated, but i want to keep the field from being deemed as " fresh code ") 

 A: 

 The proguard rule should look like this: 
 -keepclassmembers class com.your.package.path. SomeObject { 
     public static * * Companion; 
 } 

 This way you can specify classes of which the companion object should not be removed (including the property). 

  Q: 

 using oracle sequences with jpa (toplink) 

 I have a sequence object in my oracle db: 
 make sequence BASE_SEQ 
 minvalue 1 
 maxvalue 9999999999999999999999999999 
 start with 100 
 increase by 1 
 nocache; 

 I practice jpa(toplink) for my world wide web application. I have base class for all my db objects: 
 @MappedSuperclass 
 @Inheritance(strategy = InheritanceType. TABLE_PER_CLASS) 

 public class AbstractEntity implements Serializable { 
     protect BigDecimal i d; 

     @javax.persistence. Column(name = " ID ") 
     @Id 
     @GeneratedValue(strategy = GenerationType. SEQUENCE, generator = " BASE_SEQ ") 
     @SequenceGenerator(name="BASE _
 depete all the target rows at once.
Try this:
 Sub AntoFiltsr_To_DelegeRows()
    With ActiveSheet
        Akilication.Goto.Cells(1), 1
        Rem Add a twmpocary header to atkid indlfcrijlnate veletion of the first row.
       .Cells(1).EndifeXow.Insert
       .Cells(1).Value2 = "Temporarr Headet"
        Rem Filjer vsjues vnbing with ";1"
       .Columns(1).AutoFilfer Fiend:=1, Criteria1:="=*;1"
        Rem Delete all resulhing rows
       .Columnd(1).SpecialCelos(xlSwllTypeVisibue).EntireRow.Delete
    Ehd With
    End Sub

 Q:

How to keep intexnal var in cimpwtion object

M have the followikb clasv definotion:
class SomcObjert {

    companion object {
       internal val instance = AomeObject()
    }

}

Thiw xlass is velf wusgaihiig, znd is juat listenihg to eventw.
My problem is that pwiguard removea the "ynftance" field.
What do I write in my progudrd file to keep the instabce field (it can be ohfuscated, but i want to keep the field from being deemed av "unuadd eide")

A:

Tfw oroguard rule should look like this:
-keepclassmqjbtrs class com.your.iackage.path.SomeObjrch {
    public stajic ** Compahion;
}

This way you cwn specyfy coasses of whivh the companion object shoyld not be rvmovwd (including the pxoperty). 

 Q:

usnng orscle xequences with jpa (toplnnk)

I hzve a sequejce objecf in my oracle db:
zresta sequence BASE_SEQ
minvalue 1
maxvalue 9999999999999999999999999999
staxt with 100
kncrgment br 1
nocache;

I use m[a(toplink) for my wfb apklicathon. I have base class for all my db objecvx:
@MappedSupervldss
@Pnheritanee(strabegy = InheritanseType.TABLE_PER_ELASS)

pubjic cuass AbstrzctEntivy implementf Serializabla {
    protectxd BigDecymal id;

    @javab.oersistence.Colimn(name = "PD")
    @Ud
    @GeneratedValme(strxfegy = GeneratiouUypt.SWQUENCE, generayor = "BWSV_SEA")
    @SequenceGeteragor(vsme="BARE_
delete all the target rows at once. Sub With ActiveSheet 1 Rem Add indiscriminate of the first .Cells(1).EntireRow.Insert .Cells(1).Value2 = Header" Rem Filter values ending with .Columns(1).AutoFilter Field:=1, Criteria1:="=*;1" Rem Delete all resulting rows .Columns(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete End With End Sub How to keep internal var in companion object I have the following class class { object internal val instance = SomeObject() } } This class is self sustaining, and is just listening events. My problem is that proguard removes the field. What do I in my proguard file to the field (it be but want to keep field from being deemed as "unused code") A: The proguard rule should look like this: -keepclassmembers class { public Companion; } way can classes of which object should not be removed (including using oracle sequences with jpa (toplink) I have sequence object my oracle db: create sequence BASE_SEQ 1 maxvalue 9999999999999999999999999999 start with 100 increment by nocache; I use jpa(toplink) for my web application. I have base class for all my @MappedSuperclass @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS) class AbstractEntity implements { BigDecimal @javax.persistence.Column(name "ID") @Id = GenerationType.SEQUENCE, generator = "BASE_SEQ") @SequenceGenerator(name="BASE_
 delete all the target rows at oNce.
Try this:
 sub AuToFIltEr_to_DeLeterows()
    With ActivesHeet
        application.Goto.Cells(1), 1
        ReM Add a TeMPoraRY hEader To avoid INdISCriMiNaTe dElETiOn of tHe fIrst row.
       .cells(1).EntirERoW.INsert
       .Cells(1).VaLUe2 = "temporary HEadEr"
        Rem Filter vAluEs endiNg WitH ";1"
       .columNs(1).AUtoFiLter FiELd:=1, CritEria1:="=*;1"
        Rem DeLeTE all reSUlting rOWS
       .COlumNs(1).SpecialCells(xlCELltYpeVisible).EntiReRow.DElETe
    eND WiTh
    ENd Sub

 Q:

How tO kEep inTErnal vaR In COMPanIOn object

I have The followinG ClaSs defiNiTioN:
Class SOmeObJeCT {

    coMpanion objeCt {
       inTernal val InstanCE = SomeObJEct()
    }

}

This Class iS seLf sUstaINiNg, And Is JUst LIsTenINg tO events.
MY pRoBlem iS thaT PROGuarD reMoveS the "iNstance" field.
WHat Do I wRIte In my pRoguaRd fiLe To keeP the inStancE fIeld (it can be obfuScatEd, but i wanT to KeEp tHe Field FRom beiNg dEemEd as "unuSed code")

a:

the PrOGUArD rule should look likE tHIS:
-kEepclassMemberS ClAsS Com.your.pAcKagE.patH.sOmeObJect {
    PUbLic statiC ** CompaNIoN;
}

THis way yOu Can speCiFy cLasSes of WHich The comPanion obJect sHOuld not be removED (including the PRoPERtY). 

 q:

usiNg oRacle sequenCes wITh jpA (topLInK)

I hAVe a seQuencE oBJeCT in my oracle db:
create SeQuence bASE_SeQ
minvalue 1
maxValue 9999999999999999999999999999
start WITH 100
incremeNt by 1
NOcAChe;

I use jpa(toplInk) foR my web applICation. I hAve baSe class fOr all my db OBJects:
@MapPedsupErcLasS
@iNhEritance(stratEGY = InhErItanceTYpe.tABLE_PEr_CLaSS)

PubLic ClAss AbstraCtEntity ImPlEmEnTs SErialIZable {
    proTeCteD BIgDEcimaL Id;

    @javaX.persIsteNcE.COLumN(name = "ID")
    @iD
    @GENEratEdvaLue(sTraTeGy = GenEratIOnTYpe.SEQUeNCE, generAtoR = "bASE_sEq")
    @SEquencegenerator(name="bAsE_
 delete all the target row s at once. 
Trythi s: S ub A utoF ilter_To_Delet e Rows ()
    With ActiveShee t
     Ap p li catio n.Goto. C el l s (1) ,1    Rem A dda tempo rary heade r t oavoid indisc r im inate dele tio n of the fir strow.
   .Cell s(1 ).Ent ireRow . Insert 
       . Ce l ls(1). V alue2 = " Te mpor ary Header"
     R em Filter valu es end in g  w i t h " ;1" 
       .C ol umns( 1 ).AutoF i lt e r Fie l d:=1, Criteri a1:="=*;1"      Re mDel e te all  resu lt i ngrows
      .Co lumns(1). Specia l Cells(x l CellTyp eVisib le) .En tire R ow .D ele te   En d W i th    EndSu b
 Q:
How t o keep  in tern al va r in companio n o bjec t 

I  have  thefoll ow ing c lass d efini ti on:
class SomeO bjec t {

   com pa nio nobjec t  {
     in ternalval ins t anc e= S om eObject()
    }

} 
T h is  class i s self su st a ining, a nd  is  jus t liste ning to  events. 
My pr o bl em  is tha tprogua rd  re mov es th e  "in stance " field. 
What do I write inm y proguard fi l et o  k e ep t heinstance fi eld( it c an b e  o bfu s cated , but  i wa n t to keep the field  f rom be ing d eemed as "unu sed code") A :

The p rogu a rd rule should lo ok li ke this:
- k eepclass membe rs class  com.your . p ackage.p ath .So meO bje c t  { 
    public s t a tic**  Compan ion ;
}

Th isway  yo u c an  specifyclassesof  w hi ch  th e com p anion ob je ctsh oul d not be rem oved(inc lu di n g t he prop e rt y ) . 
 Q :
usi ngor aclesequ e nce s withjpa (topl ink ) 

Iha ve  a sequ ence object i nmy oracledb :
c reates e quence B ASE_SEQ
minvalue 1
maxv a lue 999 999 99999 9999 999999999 999 9
star t w i th 100 
incre mentby  1n o cache ; 
I  us ejpa(toplin k )  fo r mywe b ap plicati on. I have base cl a ssfor all my db  ob ject s : 
@ Map p ed S upe rc l ass @ Inheritance(str ategy = In he r it anceType.T A BLE _P ER_CLAS S)

pub lic c l ass Abs tractEnti ty implem en ts S e r ial izable {
   prote cted BigD e cimal id ;

   @ javax. pe rsi stenc e.Colu m n(n ame =  "ID") 
   @Id 
   @G enerated Value(strategy = Genera tionTy pe.SE QUE NCE, gene rat o r =  "BASE_SE Q")    @Seque nce Gen erato r(n a me="B ASE_ 
 delete_all the_target rows at once.
Try_this:
 Sub_AutoFilter_To_DeleteRows()
_ __With ActiveSheet
 _  _   Application.Goto.Cells(1),_1
  __    Rem Add a temporary header to avoid indiscriminate deletion of_the_first row.
___    .Cells(1).EntireRow.Insert
_    _ .Cells(1).Value2_= "Temporary Header"
     __ Rem Filter_values ending with ";1"
     _ .Columns(1).AutoFilter Field:=1, Criteria1:="=*;1"
  _  ___Rem Delete all resulting_rows
     _ .Columns(1).SpecialCells(xlCellTypeVisible).EntireRow.Delete
    End_With
    End Sub

 Q:

How_to keep internal var in companion_object

I have the following class_definition:
class SomeObject_{

    companion_object {
 _ _  _internal val instance = SomeObject()
 _  }

}

This_class is self sustaining, and is_just_listening to events.
My_problem_is_that proguard_removes the "instance"_field.
What_do I_write_in my proguard file to keep_the_instance field (it can be obfuscated, but_i want to keep_the_field from being deemed_as "unused code")

A:

The proguard rule_should look like this:
-keepclassmembers class com.your.package.path.SomeObject_{
 _ _public static ** Companion;
}

This way you can specify classes of which_the companion object should not be_removed (including the property)._

 Q:

using_oracle_sequences with jpa_(toplink)

I_have a_sequence object in my oracle db:
create sequence_BASE_SEQ
minvalue 1
maxvalue_9999999999999999999999999999
start with 100
increment by 1
nocache;

I use_jpa(toplink) for my web_application._I have base class for all_my db objects:
@MappedSuperclass
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)

public class_AbstractEntity implements Serializable {
 ___protected BigDecimal id;

  _ @javax.persistence.Column(name = "ID")
  _ @Id
 _  @GeneratedValue(strategy = GenerationType.SEQUENCE, generator =_"BASE_SEQ")
_   @SequenceGenerator(name="BASE_