Microsoft Office Forums - View Single Post - Align vertical data horizontally while copying previous columns along

Thread: Align vertical data horizontally while copying previous columns along

View Single Post

Old

01-28-2019, 05:48 AM

alpha

alpha is offline

alpha uses Windows 10

Windows 10 alpha uses Office 2010 64bit

alpha uses Office 2010 64bit

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

alpha is on a distinguished road

Default

In the macro, replace

Code:

lk = .Cells(r, .Columns.Count).End(xlToLeft).Column

by:

Code:

lk = 16

Reply With Quote