Declaration of array
 

i am trying to create a macro which will delete the excel rows based on some
values. i have kept some check boxes
Eg: checkbox1, checkbox2,checkbox3 are there in the macro code
if the user has checked the box1 & 3 then we have to keep only the rows
which as the checkbox1.caption and checkbox3.caption.

please let me know a way to resolve this

Declaration of array
 

As a general rule, in Excel when deleting rows its best to delete from
the bottom up to make sure you don't get undesired results, as for the
rest, why not post the code you have for you check boxes?, where are the
checkboxes? which menu did you get the checkboxes from?

pramod;235626 Wrote:
i am trying to create a macro which will delete the excel rows based on
some
values. i have kept some check boxes
Eg: checkbox1, checkbox2,checkbox3 are there in the macro code
if the user has checked the box1 & 3 then we have to keep only the rows
which as the checkbox1.caption and checkbox3.caption.

please let me know a way to resolve this


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=65762