+ Reply to Thread
Results 1 to 3 of 3

Google excel script help

  1. #1
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Google excel script help

    Its probs simple but i cant work it out lol

    var subject = SpreadsheetApp.getActiveSheet( ).getRange("Custome text + cell C5").getValue();

    how would i get that to read like that so it combines my custom text + cell c5?
    Thanks

  2. #2
    Forum Contributor
    Join Date
    04-27-2014
    Location
    england
    MS-Off Ver
    excel 2003,2016 and google sheets
    Posts
    122

    Re: Google excel script help

    Solved it as followed

    var A ='Custom text ';
    var B = SpreadsheetApp.getActiveSheet( ).getRange ("C5").getValue();
    var subject = A+B

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

    Re: Google excel script help

    Can't you use this?
    Please Login or Register  to view this content.
    PS Can you add code tags when posting code?
    If posting code please use code tags, see here.

+ 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. script to run the macro from Vb script with out opening the excel file
    By chandanp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2021, 03:33 AM
  2. Integrating Mainframe emulator script with excel's vba script
    By Himanshu Mishra in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-07-2012, 10:30 AM
  3. Excel Visual Basics Script to Search Google News
    By David44357 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2012, 04:01 PM
  4. Create VBA script to short, dedicated button in excel for script?
    By realized in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-01-2009, 11:54 PM
  5. Replies: 0
    Last Post: 11-05-2009, 04:47 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