Search results for query: *

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...

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...

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.

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

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...

I'm trying to print 0 and 1 in a range of cell but I can't get it work: I keep getting all 0 values Dim myRange As Range, i As Integer, b As Integer ActiveSheet.Range("A1:a10").Select i = 1 For Each myRange In Selection.Cells b = i - 1 myRange.Value = b...

The use of the controlsource property of the text box generates a run-time error 380: could not set the controlsource property. Invalid property value. 'this line of code was put in the initialize section of form module. frm1.txtCICM.ControlSource = Sheets("VAR").Range("L4").Text

Good Morning - I have some problem with this function, it's running into an infinite loop. All I want is to insert rows based an a number. For example if: frmSAGE.txtConsolePorts.Text = 5. Insert 5 rows rngRefName = "EndNumCSLconsolports" Public Sub layout_input_sheet() Dim rngRefName...

Good Afternoon - I have a workbook with 20 worksheets and will like to re-name the worksheets with the values in a range i.e A1:A20 with the click of a command button. How do I do this? Code example: dim ws as worksheet, rng as range sheets("Sheet1").select...

Good Morning - I want to do a find All on a value in excel and write the result(s) to a worksheet. Is this possible.....Thanks.

I have an Excel VBA with Modules in it. I want to remove all the modules after a user clicks a commandbutton. How can I do this?

I have three SP (with date as the input parameter) and I will like to create a single SP by combining all three SP. Is this possible, if yes how do I go about doing this. Thanks. Note: The logic is to execute each SP and store the result in a temporary buffer and then use a select statement to...

Good Morning - I have a datagrid with multiple columns and rows. I will like to underline the values or data in a single column. Setting the properties underlines all the columns. Is this possible - underlining a single column in a datagrid. Thanks.

On the client computer, when you preview the report and click the export toolbar button, the Export Dialog box comes up and I select my format and Destination. After the export dialog box I select the range. After this I expect another dialog box (more like the save as dialog box) to show so I...

On the client computer, when you preview the report and click the export toolbar button, the Export Dialog box comes up and I select my format and Destination. After the export dialog box I select the range. After this I expect another dialog box (more like the save as dialog box) to show so I...

Good Morning - I can't use the export button from crystal report viewer to export. I'm not getting prompted for a destination. I think I have all the dll's to make it work. Thanks.