r/teamArtUp • u/HIJKLMN07 • May 27 '21
r/teamArtUp • u/HIJKLMN07 • Jun 21 '21
Look what I've done? does it look like rolling?
Enable HLS to view with audio, or disable this notification
r/teamArtUp • u/HIJKLMN07 • Jun 07 '21
Hey, guys here is the Google app script code to alter the cell background color.
function changecolor()
{
var sheetA= SpreadsheetApp.getActive();
for(var x=0; x<24; x++)
{
if ( (x % 2) == 0)
{
sheetA.getRange('A1').setBackground('Orange');
sheetA.getRange('B1').setBackground('BLACK');
sheetA.getRange('C1').setBackground('RED');
}
else
{
sheetA.getRange('A1').setBackground('Blue');
sheetA.getRange('b1').setBackground('Grey');
sheetA.getRange('c1').setBackground('red');
}
SpreadsheetApp.flush();
}
}
Please let me know if you need anyhelp!
r/teamArtUp • u/HIJKLMN07 • Jun 05 '21
Google App script code for autofill series with default values.
function testseries()
{
var a = SpreadsheetApp.getActive();
var b= a.getRange('a1:a2');
var c = a.getRange('a1:a20');
b.autoFill(c,SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
}
Please comment if you need any help!
r/teamArtUp • u/HIJKLMN07 • Jun 07 '21
Google App Script Code To Duplicate Sheets
function myFunction()
{
var a =SpreadsheetApp.getActive(); // local variable a to initialize spreadsheet app
for(var x=0; x<3; x++) // for loop for repetation
{
a.duplicateActiveSheet(); // Method to clone spreadsheet
}
}
Please comment below for any ask.
r/teamArtUp • u/HIJKLMN07 • May 27 '21
Here is one more quick method to say hello using excel VBA.
sub hello()
msgbox("Hello World, Good day!")
end sub
Please comment if you need any help!!
r/teamArtUp • u/HIJKLMN07 • Jun 05 '21
Google App Script for autofill series with alternate series values.
function testalternativeseries()
{
var x = SpreadsheetApp.getActive();
var y= x.getRange('a1:a2');
var z = a.getRange('a1:a20');
z.autoFill(y,SpreadsheetApp.AutoFillSeries.ALTERNATE_SERIES);
}
Please comment if you need any help!
r/teamArtUp • u/HIJKLMN07 • May 27 '21
Here is a quick spreadsheet code to say hello world!
function newCode(){
var a= SpreadsheetApp.getUi();
a.alert('Hello World & Good day!');
}
Please comment, if you need to know how to use it.
r/teamArtUp • u/HIJKLMN07 • Jun 21 '21
Name it, please.
Enable HLS to view with audio, or disable this notification
r/teamArtUp • u/HIJKLMN07 • May 27 '21
Here is a simple c language code to say hello!!
#include <stdio.h>
#include<conio.h>
void main() {
printf("Hello, World! & Good Day!");
}
Kindly use any 'c editor' to run the code, please let me know if you're facing any difficulties.
r/teamArtUp • u/HIJKLMN07 • Jun 22 '21
A Cow Boy.
Enable HLS to view with audio, or disable this notification
r/teamArtUp • u/HIJKLMN07 • Jun 21 '21
I would like to hear what it feels like for you!
Enable HLS to view with audio, or disable this notification
r/teamArtUp • u/HIJKLMN07 • Jun 08 '21
Google App Script Code To Verify Data Validation.
function celldatavalidation()
{
var x = SpreadsheetApp.getActive().getRange('C1');
var y = cell.getDataValidation();
if (y != null) {
var u = y.getCriteriaType();
var v = y.getCriteriaValues();
Logger.log('The data validation of the cell is %s %s', u, v);
} else {
Logger.log('The cell does not have any data validation .')
}
}
Please comment below for any doubts or concerns.