How to insert a column at the beginning of the sheet

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
conjure
Pro Scripter
Posts: 63
Joined: Thu Jan 12, 2012 3:05 pm

How to insert a column at the beginning of the sheet

Post by conjure » Sat Mar 11, 2017 10:04 am

Is it possible to insert a column at the beginning of the sheet in EXCEL?

wells50
Newbie
Posts: 14
Joined: Sat Mar 04, 2006 9:58 pm
Location: Edina, Minnesota USA
Contact:

Re: How to insert a column at the beginning of the sheet

Post by wells50 » Sat Mar 11, 2017 2:41 pm

The shortcut key combination, Ctrl-Shift-+ (Control Shift Plus) brings up a menu. Press C and Press Enter to insert a column. So the MacroScheduler code would look something like:
Press Ctrl
Press Shift
// Insert a short delay after every Send command
Let>SK_DELAY=20
Send>+
Release Shift
Release Ctrl
Send>c
Press Enter

You need to start with the focus on any cell in the first column or with the first column selected.

I am not quite sure if you were looking for just the Excel shortcut or MacroScheduler code. Now you have both.
Wells H. Anderson
Active Practice LLC

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts