element

Hi. I have this function that is supposed to delete the element of an array at a required index. All input arrays start from 1 and are 2-dimensional. However, at the ReDim stage, it gives me an error that says subscript out of range. I can't seem to figure out what is wrong with the code. Sub...

Hi All, We have moved website and I was trying to write a VBA macro to automatically fill the new site with the old site's contents. I can populate the normal text fields; however I can't populate the 'main' box which let's you write HTML text. I can't seem to reference it and add a value - it...

I was wondering if it is possible to use a For Each-Next construct to cycle through each element of an array, as one does with object collections? In other words, can an array and its elements be treated as objects, or is the only option to use a nested For-Next construct with the appropriate...

Hi all, I have thought and array'd myself into a corner and would love a guiding light on this one... :confused: I have 2 arrays and want to populate a third with the values that match between Array1 and Array2.(up to this point everythign works) And (this is where I am stumbling) I want...

When I run the macro below I get this error - Method 'Busy' of object 'IWebbrowser2' failed. In debug this line is highlighted - While ieApp.Busy Or ieApp.ReadyState <> 4: DoEvents: Wend Also I think I have set the variables wrong for pid and vid. They are hidden elements in the same form...

I have the Bill Jelen book "VBA and MACROS" but I am missing something pretty basic. I want to load a string to an array element and then examine a character or set of characters within it. For instance, I want to load "Ph: (212) 555-1212" and examine if the first three characters = "Ph:" or...