• 0

help with vba for excel code


Question

i keep getting a type mismatch error. what did i do wrong?

note, i declared tricor and oos as ranges.

If radOverall Then
    
    If chTricor Then
        Set Tricor = Range("RankTricorAll")
        TricorCount = 1
    Else
        Set Tricor = shRankings.Range("B3      TricorCount = 0
    End If
    
    If chOOS Then
        Set OOS = Range("RankOOSAll")
        OOSCount = 1
    Else
        Set OOS = shRankings.Range("B3      OOSCount = 0
    End If

shRankings.Range("AverageAll").Formula+ OOS

End If

thanks.

edit: i know what i was doing wrong, but i couldn't find a way to fix it. so i just coded it so that it would change the named ranges. it's not pretty, but it works. ah well.

Link to comment
https://www.neowin.net/forum/topic/390904-help-with-vba-for-excel-code/
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • That is typically how his products go. They start off with a photoshopped image or slapped together pre-production sample. If they get enough orders, they make them, if they don't, they cancel and send refunds. Art of the deal, lol.
    • The idea of an adversary saying "oh darn it, the keys are on a TPM chip so we can't get them" is probably too good to be true.
    • PowerToys is getting a big Dashboard redesign by Taras Buria PowerToys currently has 28 utilities to enhance your user experience (the latest addition arrived in April). You can check out the list of all modules and quickly toggle them on or off on the dedicated Dashboard page that greets you each time you open PowerToys. However, with the increasing list of tools and their vast customizability, many may feel that the Dashboard is a bit undercooked and lacks more polish and useful features. If you think so, Microsoft has some good news for you. In a new PR on PowerToys' GitHub, Microsoft engineers agree that the Dashboard needs improvements, even though it worked fine in earlier days with fewer modules. The proposed solution for the overcrowded Dashboard is a redesigned variant, which looks more similar to the Windows 11 Settings app. With the suggested variant, you get much more from Dashboard: a quick link to the latest changelog, various warnings that need your attention (like conflicting shortcuts), an update button, Quick Launcher, shortcuts for your modules, and a list of available tools. A search box for modules and settings is also there to help you find stuff that you need. Here is how Niels Laute, a software engineer working on WinUI and PowerToys, describes the proposed redesign: Since PowerToys is an open-source project, other developers are welcome to contribute their ideas. One of those ideas is implementing SplitView so that you can open each module's settings without leaving the Dashboard page. Unfortunately, there is no information on when Microsoft will ship the redesigned Dashboard. While we wait for the June 2025 update, check out these three useful plugins for PowerToys Run. What other changes would you like Microsoft to add to PowerToys? Share your thoughts in the comments.
    • But AI is not turned off completely, you can hide stuff, but AI is still there, even on Windows 10 to a lesser extent. You use different MS apps on Windows 11 and again 10 to a lesser extent and AI is there, sure you don't have to use it, but why not just give an easy option to disable all AI? Even Google does that on Android. If you don't think that the MS account is not forced, then I do wonder what you think is forced. Sorry, but it is forced, try and install Windows 10 and 11 without an MS account? You will find that you can't officially, sure there are some ways to get around to and even those are getting more difficult to use as MS decides to stop people using them. My Mac on set up ask you if you have an Apple account, but it is so easy to say, nope, I have not got one. I don't understand why the pushing for an MS account, not all of us want to use the cloud for storage and for most people that is the only advantage of having an MS account, unless you play some games. I have heard that Windows 11 still pop up about using Edge when people don't certainly on updates. I get a pop-up on my Windows 10 machine now and again saying let's finish setting up. It is set up, what they want me to do is to say what I am using the computer for. Nothing to do with them, no idea what they do if I go ahead with what ever they want me to do as I skip, but there should be a no, thanks. I don't use the search in Windows, never have, unless I am looking for files, I use Duck Duck go in my default browser, but some people do, and they should not be forced to use Bing, which in the UK is a load of poop and then if they do click on an in it should open in the default browser.. This is the sort of thing I expected from Apple, Microsoft is far worse than Apple. Context menus again, people should not have to do tweaks, it should be a simple setting.
  • Recent Achievements

    • Week One Done
      patrickft456 earned a badge
      Week One Done
    • One Month Later
      patrickft456 earned a badge
      One Month Later
    • One Month Later
      Jdoe25 earned a badge
      One Month Later
    • Explorer
      Legend20 went up a rank
      Explorer
    • One Month Later
      jezzzy earned a badge
      One Month Later
  • Popular Contributors

    1. 1
      +primortal
      636
    2. 2
      ATLien_0
      275
    3. 3
      +FloatingFatMan
      171
    4. 4
      Michael Scrip
      155
    5. 5
      Steven P.
      132
  • Tell a friend

    Love Neowin? Tell a friend!