Excel nightmare

[tait]

I am trying to pass the contents of cell A1, A2 etc to a new worksheet only if the corresponding check box in cells B1, B2 etc are selected. I also need the new worksheet to show the cells neatly formatted with no blank cells.

Thanks

 

[bryanbayfield]

Not a lot of detail there - what part exactly are you struggling on?

You can access the check box values via the OLEObjects collection of the sheet.

If you've named your check boxes eg chk_1, chk_2, etc, then you could have a loop eg

for i = 1 to 25
    if sheet1.oleobjects("chk_"&i) = true then
        ' da de da, pass it over
         end if
     next

Gotta agree that manipulating OLE Objects is a right pain in the cahoonies.

Hope this helps.

Bryan.

 

[Tiglet]

What have you got so far and I'll have a look - I've done something similar myself

 

[tait]

Thanks Guys, I've actually managed to acheive what I was looking for using Worksheet functions

tait