Selecting columns to print in Google Sheets via VBA?

[TAPS_MikeDion]

Hi everybody,
What I am looking to do isn't as simple as the Thread Title may sound. Is it possible to use VBA to select specific columns (A - L, using the values from row 1, i.e. Last Name, First Name, etc) to print.

For example:
I have columns with peoples names, ID numbers, addresses, DOB, etc that go from column A to column L (12 columns in all.)
However, I may only want / need to print the data from a total of 5 columns, but the columns I may need to print aren't always the same. I can't manually go from column-to-column and select the columns, then print and select active cells, because it only goes by the last column I select.

I'm hoping to be able to use VBA to allow me to select only the columns I need to print, like so...

	A​	B​	C​	D​	E​	F​
1	Last Name​	First Name​	Middle Name​	ID Number​	Street Address​	City​
2	Smith	Joe	William	90	123 This Street	Chicago

What I'd like to know is if there's a way to choose from a list of column headers (example: Last Name, First Name, ID Number only) and then print just those columns (A, B & D.)

Thank you SO MUCH if you come up with a solution to this problem!

-Mike

 

[MARK858]

Google sheets doesn't support VBA, it uses Apps Script

 

[TAPS_MikeDion]

Ugh. So Apps Script cannot be written like VBA then? I don't know Apps Script and I know only the basics when it comes to VBA.

Thank you for your response, by the way.