boxedmachine

Hello friends,

I'm stuck with this problem for a few hours now and I'm out of ideas. As of right now, I'm able to get it to comment a date and time to the latest modified cell. But it adds it to all cells making the sheet quite difficult to read.

Here's what I have so far:

function onEdit()

{

var sheet = SpreadsheetApp.getActiveSpreadsheet();

var cell = sheet.getActiveCell();

var comments = cell.getComment();

if(sheet.match("text")){

comments = comments + "Modified: " + (new Date());

cell.setComment(comments);

}

}

​

I can't seem to get the if function to work. What do I need to change? Thanks in advance.

Hello again friends, I need help again.

I'm trying to do some alternate naming of rows, so for instance in a1 I have Tim and a2 I have Sally. When I select and pull it down I see the tool tip alternating the names (good) but when I release, Tim covers everything (Bad, Tim is not that hardworking). Do I have a setting I need to change?

Edit: I found a workaround, it was a filtered list, so copy and pasting it as a new list worked. But I'd like to know if there's a way to keep the filter and do this.

Hey guys, I'm just learning Python and Selenium and I've been trying to run a simple google search. I managed to find the element and input some text in the search bar on https://www.google.com/, but when I use:

driver.find_element_by_name("btnK")

It at first thrown me the below error:

Message: element not interactable: element has zero size

Now I'm getting:

Message: element not interactable

I've tried looking around but I'm still not sure how to fix it. Thanks for the help!

By the way, is there a discord server where we can drop question and answers?

And why is it the Alpine Renault A110 1600 S?

Hello again friends

I'd like to select columns with a specific header and then stop at a certain row (like 'A1000". I'm doing this via macro and found one that's able to find and select columns based on the name of the column. However, it selects the entire column until the end of time, this is bad because once I paste my formula in, my laptop would suddenly take off like a helicopter and crash.

Anyway, is there a way for me to add a stop row for the selection?

Heres the partial code that I'm using:

Select Named Columns

xStr = "Name"
Set xRg = Range("A1:EG1").Find(xStr, , xlValues, xlWhole, , , True)
If Not xRg Is Nothing Then
    xFirstAddress = xRg.Address
    Do

Hello my friends

I'm looking to pull some data from a sheet using index and match. Some of the data is missing in the sheet and will return a 0, while others will return an N/A (because the Indexed row isnt found).

What I'd like to do is to add an IF function into the index match function to return the following:

If the column to match is not there in the sheet, return: "column not found"

If the data in the cell is not there in the indexed area, return: "data not found"

My issue (among many other personal issues) is that I can return the error when there is no data in the cell just fine, but I can't return the correct data in the index. Instead it will show an error (#VALUE!)

I tried g