+ Reply to Thread
Results 1 to 4 of 4

Google Sheets: Argument cannot be null...

  1. #1
    Registered User
    Join Date
    02-13-2021
    Location
    Lithuania
    MS-Off Ver
    2013
    Posts
    6

    Google Sheets: Argument cannot be null...

    Hi,

    I'm trying to do some coding to Google sheets, I'm doing it exactly by video tutorial, but as soon as I put argument "list" to function (applyValidationToCell) I get error: Argument cannot be Null: values. applyValidationToCell (at) Code(dot)gs:11

    I do not think I need to attach sample file because it is exactly like in video and yet so far into tutorial it has nothing to do with sheet data.

    video: YouTube /watch?v=s-I8Z4nTDak

    Please Login or Register  to view this content.
    if I don't put it in call function it works:
    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Google Sheets: Argument cannot be null...

    The code works fine for me when I manually run it.

    How are you executing it?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    02-13-2021
    Location
    Lithuania
    MS-Off Ver
    2013
    Posts
    6

    Re: Google Sheets: Argument cannot be null...

    just like in the video
    Attachment 720218

  4. #4
    Registered User
    Join Date
    02-13-2021
    Location
    Lithuania
    MS-Off Ver
    2013
    Posts
    6

    Re: Google Sheets: Argument cannot be null...

    I think I fixed it my self... I chose wrong function near Debugging button. So far it works. Sorry for wasting everyone's time...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google Sheets: Condition formatting in Google sheet
    By cyee in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 02-18-2021, 05:35 PM
  2. [SOLVED] Google sheets script to download file and save it to google drive folder and use it's data
    By western in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 01-18-2021, 01:31 PM
  3. [SOLVED] Google sheets vba to download file and save it to google drive folder and use it's data
    By western in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2021, 08:48 AM
  4. Google Sheets Master Sheet that pulls in data from other sheets with the last edit date
    By Badvgood in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 12-19-2020, 12:04 PM
  5. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  6. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  7. Function (array argument, range argument, string argument) vba
    By Witek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2005, 11:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1