smart

OK, so I've been running macros in this spread daily literally for years (well during the hockey season) with no trouble All of a sudden I keep hitting Smart DNS Proxy....in other words, when I run the macro it returns no data because it's being redirected and I've no idea why. Looking online...

Hello all, Merry Christmas! :) I'm new here but feel I'm gonna learn a lot from all you smart people! Hoping you can help me with a little dilemma please... I want to be able to return 4 names in B4, D4, F4 & H4, this detail will be from sheet 2 and will be based on the number entered in B2...

Hi there! This script changes the cell color when doubleclicked, but i don't want it to "work" for certain rows and columns because they are headers and other text. So...i want this script to be excluded from: row 1 2 3 4 5 12 21 And column: A I know you smart people knows how to fix this...

Trying to perform an index and match based on partner name. If name is found then look to see if they have services in Agriculture (and then Airway, Smart Building, etc.) from table1[[V1]:[V4]]. If found return partner name. <tbody> Company Agriculture Airway Smart Building Smart City...

Hey all, I've got another slight query: I have this code: Sub Copy() Application.ScreenUpdating = False Dim wkbSource AsWorkbook, wsDest As Worksheet Set wsDest =ThisWorkbook.Sheets("SMART Raw Data") Dim lColumn AsLong lColumn = 3 Const strPath AsString =...

Hi, I am working on a macro where I want column A to drag and drop a formula when i run the macro, but when I run code below i get this error "Run-time '1004': Method 'Range' of object'_Global' failed. I am learning VBA as i go so i will really appreciate help with code below...

Hey All, This formula is really simple but way too long. There must be a way to make it shorter but I'm not smart enough to do it. Any help would be great...

Script gives me problems. I dont think there is a way to do this without script though. I'm wanting to use an image as a button that will print only a section of one sheet. Heres a twist but I think it's possible if you're smart like you guys are. The area I wan to print will always be columns...

I have been using Smart Indenter for years and have recently upgraded to excel 2016. can't use it any longer. I see that there is a possible work around involving deleting and reinstalling the MSADDNDR.DLL file. What will that actually do to my computer? what is the difference between that file...

Using VBA, is it possible to change the RGB color (say green) of a selected element within a smart art object (say Org chart). I know that we can do it if we know the element number - how about an element selected at random? Please advise as soon as possible.

My string is from my smarthouse: 7.3.2018 10:25:40 +? 71 EnergiUte Strøm sender <MÅLEVERDI> til Smart Home Controller (DP:85) 8,430 (Netzversorgt) 74 % 7.3.2018 10:25:40 +0.0947 Smart Home Controller sender <BEKREFTELSE> til 71 EnergiUte (Netzversorgt) 58 % 7.3.2018 10:25:52 +12...

Hello All I'm looking for a formula to calculate the below scenario. company for example has 7 sku divided to 2 categories smart and none smart, person has target of the 2 categories and when the person achieve 100% of his target i need to calculate his commission based in different price per...

Hi there, Would anyone know where I could find a worksheet very similar to the Smart sheet programs - https://www.smartsheet.com/landing-b - which seems to be excel based? :eeek: I don't need most of the features just the ability to have: - Line based organising with collapsible task with sub...

Hi Everyone, <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am trying to create a script that will clean data in the table using a specific way. <o:p></o:p> Here is the file with the original data and the results:<o:p></o:p>...

Hi, I need to have what I call a smart Filter. If I have 3 Columns and they all have values such as 1 2 3 2 2 3 2 1 3 3 3 3 3 1 1 I want to have a filter in which I only have to filter one column for the number 1, and have a filter for all three columns: 1 2 3 2 1 3 3 1 1 Thanks JDC