watch

Hi all, Got a quick question whether its possible to include totals in my database according to the drop-down I select. I currently have a database that have 4 different variables and another tab that brings me a P&L view using sumifs according to the chosen variables. There's a drop-down...

Hello All. if I select a cellor cells to add to the watch window, the columns added are: Book, Sheet, Name,Cell, Value, Formula Because I'm onlyinterested in the value, and as I don't want the watch window to take up a lotof unnecessary space. I reduce the width of the window, and scroll to...

https://www.betexplorer.com/soccer/scotland/championship/ayr-morton/EXyx7gQB/#1x2 DoEvents bookmakerFound = False Set tRows = HTMLdoc.getElementsByTagName("TR") For Each tRow In tRows If tRow.getElementsByTagName("TABLE").Length = 0 Then...

Hi How can I monitor a particular range and do an action if something in this range changes? I know how to monitor an entire worksheet, but not how to watch only a particular range or even cell.

Hi all, So I'm working on improving my ability to write and understand macros (I'm entirely self-taught in excel, so I figure why change that now?). Basically writing Macros, then looking for ways to make them better/faster. Anyway, when I'm designing subs and functions, I put watches on the...

Hello to every one, Ioan here I don't succeed to create dynamic array for range of cells, this dynamic aaray will be usefull to aproximate a specific value: Please watch the image to understand what i want to say https://imgur.com/a/4vQHP Thank's

Greetings, I am not receiving a value for the variable "h" when it runs over the line below. I added "h" to the Watch box and it is reading "Out of Context" when it runs over this line. Why might this be occurring? Dim h As Integer Dim k As Integer Dim l As Integer h =...

Hello! I have two days since i started to find a solution for my problem. I already tried to use VLOOkUP function but it fails because i have multiple rows with same id( and i need every each one, so i can't remove duplicated rows). This is how VLOOKUP fails.(i want to merge the first 2 tables...

DBly 07:28 PM Today Hello, I have a stop watch in my excel file that relies on a start/stop button. I'm trying to create a VBA to click the command button (Start Timer) when the Workbook is opened and click the button (Stop Timer) and save when the excel file is closed. The stop watch VBA I'm...

All cells are formatted as "General". Range(Cells(1, 1), Cells(5, 5)) all contain a 2. Getting type mismatch error - see "Watch" at bottom. Declared in a module: Option Explicit Public OldData As Variant Public Newdata As Variant Public TmpData As Variant Worksheet: Option Explicit Private...

Hello,The following code generates a Run-time error (13) Type mismatch: Dim IloscWierszy As Long IloscWierszy = Application.VLookup(.Cells(i, 2).Value, _ "'[" & PlikBudżet.Name & "]" & PlikBudżet_arkusz.Name & "'!R" & WierszKosztyPensji_Budzet + 2 _ & "C" & OstKol_Budzet & ":R" &...

I was trying to reposition the Watch window so I cold see it and the Immediate window at the same time. I guess I must have moved it too close to something, because it jumped onto the the main code window. I was able to get it free using Tools | Options | Docking, but now it has latched onto the...

Hey All, I have recently started using the Watch Window a lot, and I as wondering if there is a way to retrieve data from the Watch Window. In the Object Browser, it looks like there are a few members of Watches (Add, Application, Count, Creator, Delete, Item, Parent). Is there a way to use...

Thanks for taking the time to read this. Very novice to Excel compared to most. Thanks for your advice. We use basic conditional formatting of duplicates often at my work. If two cells are exactly the same I know how to make them light up. So my question is how can I get Excel to identify...

Here's the algorithm for what I'm trying to accomplish: Watch folder for a CSV file Open file in Exsmell Fold, Spindle and Mutilate the file Save said file to an .xlxs file with the same file name Email file. If you're wondering why I need to do this, I have a PHP script that generates a...