Recent content by FJAY

Implemented the feedbacks but I'm still getting the send error report. Thanks.

I keep getting a send error report when trying to delete some worksheets using the function or macros below: Public Sub delete_worksheet() Dim shtDelWorkSheet As Worksheet For Each shtDelWorkSheet In Application.Worksheets Select Case shtDelWorkSheet.Name...

Remove all the links and leave the cell contents in place. Thanks.

Good Morning - I have hundreds, may be thousands of hyperlinks spread across a worksheet. How do I remove this hyperlinks dynanmically? Thanks.

Excel seems to crash when I try to delete worksheets. The procedure seems to be working in previous release of my tool. Public Sub delete_worksheet() Dim shtDelWorkSheet, mySheets mySheets = Array("A", "B", "C" "D", "E") For Each...

Good Afternoon - I have a worksheet and I will like to autosize all the cells with comments. The code below works if the used range all have comments. ActiveCell.Comment.Shape.TextFrame.AutoSize = True

Good Afternoon - I have a workbook with about 30 worksheets. Each worksheets have numerous comments in it. When I created the comments boxes that sized to specific width and lenght based on the text contents. But, for some reason the comments boxes seems to have a mind of their own and shrink or...

The controls are checkbox object. Thanks.

Good Morning - I have a worksheet in excel with about 20 checkboxes and I will like to set the value of each checkboxes on the click of a button without having to spell out the name of each checkboxes. Is this possible. I know in Visual Basic I can create an array of checkboxes. But I don't know...

I keeo getting this error message Device I/O Error. What's the cause of this problem and how can I fix it. Thanks.

I have this problem and I can't open my file because of it. Anytime I try to open it, I get the error. How can I open the file again.

How can I fix or correct this error in Excel? too many different cell formats.

It won't work because I've changed the names of the checkboxes from checkbox1 to i.e chkUSP, etc.

Good Morning - I created a form userform in excel with about 20 checkboxes and I will like to set the value of each checkboxes on the click of a button without having to spell out the name of each checkboxes. Is this possible. I know in Visual Basic I can create an array of checkboxes. But I...

Molby, it worked fine. What about of I want to print 0,0,1,1,2,2,3,3 and so on in the same range. Thanks.