Software
dguille...@gmail.com
-Original Message-
From: Thomp
Sent: Monday, January 30, 2012 12:39 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Checkbox disappears when Macro Run
Here is the code Sam..when I added your code line it eliminates all
the lines not just those
I have this weird problem that whenever I run a macro I have the
clears some data.. the checkbox control at the top
disappears..Stranger still is if I drag the last row of data or copy
and paste in a new row the checkbox reappears.. I have already tried
changing the format control to the option
Try adding a line at the end of the code
Application.ScreenUpdating=True
Regards,
Sam Mathai Chacko
On Mon, Jan 30, 2012 at 8:59 PM, Thomp williamth...@gmail.com wrote:
I have this weird problem that whenever I run a macro I have the
clears some data.. the checkbox control at the top
Here is the code Sam..when I added your code line it eliminates all
the lines not just those completed
Sub FilterDeleteColumnF()
Dim Lastrow As Long
Range(N:N).AutoFilter Field:=1, Criteria1:=þ
Lastrow = Range(N Rows.Count).End(xlUp).Row
If Lastrow 3 Then Range(A3:A
$$ Checkbox disappears when Macro Run
Here is the code Sam..when I added your code line it eliminates all
the lines not just those completed
Sub FilterDeleteColumnF()
Dim Lastrow As Long
Range(N:N).AutoFilter Field:=1, Criteria1:=ş
Lastrow = Range(N Rows.Count).End(xlUp).Row
If Lastrow 3 Then Range(A3
Can u attached sample file.. I want to look at that
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Thomp
Sent: Jan/Mon/2012 08:59
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Checkbox disappears when Macro Run
I