cellslast

  1. W

    Method range of object failed - Please help

    Hi All, I am trying to define a variant based on the results of another loop and I am currently using the below syntax, however i am getting a method range of object failed. I've been trying for about 3 hours to figure this out and have made some changes but can't seem to see what's going...
  2. W

    VBA Dynamic cell entry from earlier statement

    Hi All, I am trying to use the following to define the first and last value of an entered array (partial code shown below). is there a way to make this work? For j = 1 To finalrow3 For l = 1 To 200 If base(j, 1) = firstlast(l, 2) And Year(dates(j, 1)) <= firstlast(l, 1) And...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top