objects

I am working with the lines: ArrX = Application.WorksheetFunction.Index(X, 0, 2) ArrTemp = Application.WorksheetFunction.Index(TempSample, 0, 2) DistanceMeasure = (1 - Application.WorksheetFunction.Correl(ArrX, ArrTemp)) * 100 I would like to be able to run a simple correlation using...

I would like to be able to loop through arrays to do a test. I have one big array. It is two dimensional and has 2000 objects. From this array I would like to test every consecutive set of 20 objects to compare to another array. What kind of structure am I looking for here? In other words...

Hello everyone, I am working on a UserForm where on click on button embedded objects will be open. I am using below codw for this which is working fine. However i want objects (workbook) should open as read only so no one can edit the same. Pls help Private Submit_click () If cmbox.value =...

Is there a way to copy all picture objects in a specific column over to another column as INDIVIDUAL "Picture (Enhanced Metafile)" pics? I found this code that selects all objects in a column if it helps... Sub SelectShape() Dim shp As Shape Dim r As Range Set r = Columns("a:c") For Each...

Hey everyone, I have a worksheet where the information is displayed in the following manner: a table containing 3 columns: A - List of objects B - Categories C - Comments I have a userform in VBA that is built in the following manner: 4 checkboxes (corresponding to the categories in column...

Hi Guys, I'm copying some data from a website to excel and its pasting in a individual objects. All of the objects contain text. Is there a way to convert these to a table format in excel so i can manipulate and copy and paste the data. Thanks

Hello I want to use a collection that contains different car objects. I'm familiar to do this in Java but I don't find the solution in VBA. I want to create a class car where I can create my car object with contains the following parameters make model year therefore I have to make a class...

Hello, I am trying to set a variable that I can use throughout my macro. The variable is the filename with its associated path. So far, Ive been succesfull in setting the variable and using it in certain objects, but not in others. The code is as follows: Sub ScorecardImporter() Dim...

Good day, Excel Guru's! Right to the point: After closing a userform and opening a userform from the same project (addin file) referencing global object variables, I get the RTE 91 "Object variable or With block variable not set". I normally don't use global variables, but this project is...

Hi, I have been looking at few VBA codes and sometimes confused about the usage of objects. Could any of you please help me in understanding the objects and how to use it and when to use it. For example,for 'Folders' some codes use FSO as object. And in some other codes its different. Please...

in a few quick words, how am I thinking wrong when I use Application.CountA(ActiveCell.EntireColumn.select) to return the incorrect number of 1, versus Application.CountA(ActiveCell.EntireColumn) to returna the correct count of 109 in my particular spreadsheet? I know I don't need to...

Hello, I am a novice with VBA, but I was able to get this code to work. The problem is that I want the code to apply to 29 other objects. the range of cells are from row 118 to row 123 and columns 26 to 30 (30 cells total). Each object is tied to the outcome of each cell. If the cell is...

I would like to have a function which takes in a variable (say, worksheet), and determines if that worksheet is populated. This is what I had, and I thought it was working fine, but i was wrong. My purpose is to have a 'checker' which lets me know if I have already created an object, and if...

I am rating 10 individual objects using a 1-5 numerical rating. I have data grouped by the rating value into 5 columns of data. For example the first column is the number of objects that received a 1 rating, so the 5 entries for a row might be 3, 0, 4, 3, 0 (3 #1s , 0 # 2s, 4# 3s, etc). I need...

Is there a way to have a macro select all the objects (pics) ONLY in a given range.... Columns("B:F")? Thanks

I need a non-VBA solution to bringing objects to the front (or making visible, etc.).

I have the following: CurveCol: A collection of object of type curve PointsCol: A collection of XY data points associated with the object curve Cls_Point: is an object containing the xy Data Sub Get_Initials_At_PXc(p As Integer, Xc As Double) Dim A As New Cls_Point, B As New Cls_Point...

Hello All, I would like to know why do we create objects for folders in vba. What does object do? Thank you in Advance! Your response is greatly appreciated!

How do I delete all pictures and objects within a given range. I've been using this code but it doesn't seem to work. Sub Clear() Application.DisplayAlerts = True Dim IA As Workbook: Dim ES As Worksheet Dim Sh As Shape Dim AddData As Range Set IA = ThisWorkbook Set ES = IA.Sheets("Executive...

:confused:I am having trouble creating VBA to delete specific objects in a worksheet before I copy that worksheet to a new workbook. I have several macro buttons and signature blocks in worksheet1 and when I click my export button I need the macro buttons to go away but the signature blocks to...