Declaration of array

[pramod]

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]

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

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

please let me know a way to resolve thi

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com