I would appreciate knowing what I am doing wrong - could someone please point me in the right direction?
I get a Run-time error 9 on the below code.
if I replace x variable to a fix number in the line Cells(col, cy + 7) = Mycycle(x) to Cells(col, cy + 7) = Mycycle(1) it works but the cycles...
Hi all, I've got 2 related questions:
(1) I am trying to define a two-dimensional array. The size of the array will vary somewhat, and each element of the array will have 3-5 subelements (overall, probably 75x5 max). Is there a way to build an array that flexes in size like that? Right now I'm...
When I try to run the macro containing the following code an "Application-defined or object-defined error" is generated
If Not IsNumeric(Application.WorksheetFunction.Mode(stock1)) Then
stock1Mode = "No Mode"
ElseIf IsNumeric(Application.WorksheetFunction.Mode(stock1)) Then
I have an Excel 2003 workbook that is much like a checkbook. One sheet is the Form, which is protected except for cells where the user enters data (Payee, Amount, Date, etc.). I am looking for a macro that will copy data from certain noncontiguous cells on the Form sheet to another...
Hi there - I'm a new member of the forum, and trying to get my head around transferring arrays into UDFs, so that I can invoke some functions instead of littering an excessively complex workbook with absurdly long arrays.
For example, I’m trying to convert the following string (with declared...
I am having problems with a value check.
I have pulled data from a csv file into my workbook. During this cut'n'paste exersize I have found that some values are n/a.
When this happens I want the value of the cell 4 to the right (on the same row) to replace the n/a.
I want to run multiple pivot tables off an array exceeding 500k cells. I
believe it would vastly improve performance. I've tried variations of the
code below to no avail.
Set Pivot_Cache_01 = ActiveWorkbook.PivotCaches.Add _
I'm trying to make my code run faster by using a dynamic Array.
However, I keep on getting an error everytime I run my code. The error is Object variableor with block variable not set.
Where the error occurs is highlighted in red.
Can someone help me out with this particular issue...
i want to check unique records from specefic column and based on that criteria i want to paste all data from main sheet to other sheet.
pls check the code below and help me to fix this problem.
Private Sub test()
Dim i As Integer
Dim ClientName() As String