Repeating Code Between Google Sheets Macros

[gmercer82]

I have two macros. One called Desktop and one called Harddrive.

For the Desktop macro it will put the word Desktop on Cell A3

It will then copy parts from the sheet and paste it in another sheet.

For the Harddrive macro it will put the word Harddrive on Cell A3

It will then copy parts from the sheet and paste it in another sheet.

When I am wondering is, since the code for copying and pasting the information is the exact same, is there a way I can have the code in 1 spot then recall it into the macro.

I know there is a way to do this in programming but I forget the name of it.

What I would like is:

CopyCode
Instructions for copying what I want

Desktop Macro
Put word Desktop in A3
Run CopyCode

Harddrive Macro
Put work Harddrive in A3
Run CopyCode

I would like this so if I need to make a change to the copying code, I just need to update the one spot

[jindon]

Something like this.

Please Login or Register  to view this content.

[gmercer82]

In the macro code it has the sections called function.. here is most of the code (removed some to make easier to shorter to post)

--This is the stuff I want to be different in each

In the HarddriveList Marco
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Info'), true);
spreadsheet.getRange('B1').activate();
spreadsheet.getCurrentCell().setValue('Harddrive');

In the Desktoplist Macro
spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Info'), true);
spreadsheet.getRange('B1').activate();
spreadsheet.getCurrentCell().setValue('Harddrive');


Here is an the current macro code I would like to be able to use in each

function HarddriveList() {

spreadsheet.getRange('f4:AB353').activate();
spreadsheet.getRange('f3:AB3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);

};

[jindon]

This is a VBA forum, so no idea about what you are talking about.

[gmercer82]

Sorry. I saw a marco section and thought this was the place for it. Because I thought was was VBA code.

[6StringJazzer]

This looks like a Google sheets macro to me. Are you using Excel or something else?

[gmercer82]

Google sheets. I have used this site a few times for help in stuff I was doing in sheets and open office

[6StringJazzer]

It is not VBA. It is the language used for Google Sheets macros, which is not applicable to Excel. I've moved your thread to the appropriate subforum.