class

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

Hello, I joined this forum in 2007. Back around then I took an intermediate excel class and I enjoyed it. My work at that time had me maintaining a couple of spreadsheets. this place was great. I haven't opened a spreadsheet in a decade until earlier this year. Now I'm managing some data on...

I am looking for suggestions for an online class (self guided preferred) that will teach me everything I need to know about formulas/functions that will help me clean up messy files from a lot of different sources. I have basic excel knowledge but am expecting a much heavier workload very soon...