David i could able to fix the bug. thanks for you support and help.
Regards,
Ram
On Wed, May 1, 2013 at 5:34 AM, David Grugeon wrote:
> Well, that bit works OK for me. The questions I would ask are what sheet
> is active at the time? What is the value of k immediately before the
> rows... se
Well, that bit works OK for me. The questions I would ask are what sheet
is active at the time? What is the value of k immediately before the
rows... select is run? What is the macro selecting?
There are a number of issues with your code. One which concerns me in
particular is the line
Dim i,
this particular line it is Just skipping Rows("102:" & k).Select
and deletion line also not performed.
On Mon, Apr 29, 2013 at 4:19 AM, David Grugeon wrote:
> Thanks, Ram
>
> So you are saying that it correctly does the line
>
> Rows("102:" & k).Select
>
> At that point you can look at the
Thanks, Ram
So you are saying that it correctly does the line
Rows("102:" & k).Select
At that point you can look at the spreadsheet and see that the relevant
rows have been selected. Then, when you run the next line
Selection.Delete Shift:=xlUp
It does not delete the selection.
What does
hi Team,
Can anyone please resolve my concern.
Thanks.
On Sun, Apr 28, 2013 at 12:06 PM, excel learner wrote:
> hi David,
>
> I tried step by step execution but still it is executing fine without any
> error but deletion part in first transaction tab is not done..
>
> Thanks & Regards,
> Ram
hi David,
I tried step by step execution but still it is executing fine without any
error but deletion part in first transaction tab is not done..
Thanks & Regards,
Ram
On Sun, Apr 28, 2013 at 12:04 PM, David Grugeon wrote:
> You have highlighted 5 lines
>
> Try stepping through the code and f
You have highlighted 5 lines
Try stepping through the code and finding out which line does not work as
required.
Regards
David Grugeon
On 28 April 2013 16:25, wrote:
> Hi Experts,
>
> i have come across an issue where in auto filter code is skipping over
> without performing the required
Hi Experts,
i have come across an issue where in auto filter code is skipping over
without performing the required action and running next course of action.
I Have highlighted the line where am getting error can any one correct me
where am facing this issue.
Macro is executing well but this p
