class

Hello there. Most puzzling. The following worked first time I tried it, now it fails on the highlighted line with Object does not support this property or method Simple test Hotel class: Option Explicit Private pName As String Public Property Get Name() As String Name = pName End...

Hello How would I create a formula that updates automatically when I update/change the selections in my spreadsheet filters? I have a large spreadsheet with columns for school names, teacher names, class names, subjects, students and columns for test scores. I need to count the number of test...

Hi From Object Oriented point of view, I understand Cells is a property of Range Class and its type is Range. So I understand this code cells.clear but what I do not understand this cells(1,1).value ="hello" Where it says Cells takes Row, and Column as arguments? If you check Range...

Hi, can anyone tell me what I am doing wrong here, I keepgetting the following error “Unable to get the countifs property of theworksheetfunction class Dim lastrowcolumnz As Long lastrowcolumnz = Range("a" &Rows.Count).End(xlUp).Row For i = 2 To lastrowcolumnz Cells(i, 20)...

<tbody> Class Amount Yes (Formula Below) 1 -100 2 200 </tbody> Hello, I am having considerable trouble trying to get a combo of all three to function as intended. A very simplistic explanation. If 1 class is greater than 0 and 1 class is less than 0 then take the class with the...

Dear Good People, I am having this error message: unable to get the match property of the worksheet function class. Below is my code where iam getting These Problem. Let me know what should i corret.Thanks For i = 15 To 1000 If Worksheets("Sheet1").Cells(0 + i, 6) > 3 Then...

I would be grateful to receive a steer as to the formula to use, where I have a list, that involves 20 names, in 5 different areas identified by an abbreviated label, and those names fall into either T or C types which alter frequently although the area and name does not. I need to produce a...

Hi all, I am trying to locate Meta tags from the following URL: https://england.shelter.org.uk/professional_resources/policy_and_research/policy_library/policy_library_folder/2020_group_-_fiscal_stimulus_paper However, what is passed from the result string to HTMLDoc.body.all is only a...

This probably sounds familiar, but I have been rifling through google and herd all day to find a solution. Here is some background information: The spreadsheet is for trend analysis on tests. You put in the class number, number of students, and what version of the test they are on(there are 3...

Hi Quick VBA name fill question I've got the data below in Sheet 1 of a spreadsheet. I'd like to copy the 'Class name' from Sheet 2 then fill it in the 'Class' column in Sheet 1 (column A). Assuming that the class name is in cell B7 in Sheet 2, I would have thought that the code below...

Hi Long time lurker finally signed up as I can't figure this out. Test.xlam: contains a class TestIF (Test interface) -- PublicNotCreatable contains a function RunTests (starts execution--called from a menu) which is supposed to callback to the xlsm file to instantiate the class that...

Hi, I have an excel sheet which having 60 rows (aprrox. which will change every time) and 10 column of data In Column 11 I have stored Location (i.e. "Class A", "Class B", "Class C" etc) For example : Suppose Column 11 having 4 Categories then I want to send 4 emails, after...

The word I am trying to extract from Mid string is one of 7 : "class1" or "class2" or "class3" … up to "class 7" any help much appreciated

Hi I want to use the min method of the WorksheetFunction on a range in a workbook in sheet 1, and assing the value to a variable called lastrow, like the following: LowestScore = Excel.Application.Workbooks(1).Worksheets(1).WorksheetFunction.Min(Range("B1:B5")) but i get an error 438 that says...

Is this possible in Excel? Callan Associates, among others, has for many years published a year-by-year listing of what investment returns were by asset class. The point is to demonstrate the importance of diversifying, because no asset class outperforms others from year to year. See...

I have a spreadsheet that needs to do X, Y, or Z (which are all various sums of columns of numbers) depending upon two variables: If A=5 and B<>0, then do X. If A=6 and B=0, then do Y. Else, do Z. I have a formula that works correctly without using ArrayFormula: =int(if(and(E2="5 courses each...

Hi everyone I am trying to learn about the Excel object model and i am bit confused the following code line: Excel.Application.Selection.CurrentRegion.Select In the object browser i can see that application is an child class and a property of Excel. I can also see the selection is a property...

Hi,I'm looking for a Vlookup formula where I am checking a table. If that value is found, then give me the value in a column that matches the data. Example: A B C D Class ID Class Matching...

Hello everyone. I have some custom defined VBA classes and no idea why they keep causing Excel to crash. My classes define objects. I use instances of those objects in dynamic arrays. I can't use collections because I need to edit the objects in the arrays and swap out the entries in the...

Hi I'm trying to use VBA to work out what type of vehicle is supposed to be in a diagram. So, for example: AB1XX = Class 1 AB5XX, 6XX, 7XX = Class 2 BC 11X = Class 3 BC 12X = Class 4 CD 23X, 24X = Class 5. I'm currently trying to use a Select Case statement, but the following doesn't work...