Align vertical data horizontally while copying previous columns along

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Align vertical data horizontally while copying previous columns along

01-28-2019, 05:48 AM

alpha

Windows 10 Align vertical data horizontally while copying previous columns along

Office 2010 64bit

Novice

Join Date: Jun 2018

Posts: 18

In the macro, replace

Code:

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

by:

Code:

lk = 16

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Vertical Text Alignment with Adjacent Columns	kdutrisac	Word Tables	2	06-26-2017 12:38 PM
Copying specific columns of a table to WORD and deleting rows	ffinley	Word VBA	5	12-07-2015 04:01 PM
Copying and pasting values with unequal data columns	grexcelman	Excel Programming	5	12-05-2014 11:36 AM
Vertical align to bottom of cell when row wraps to next page	lausianne	Word Tables	3	02-28-2014 05:20 PM
Copying data from sheet with deleted columns creates blanks	ZGreyArea	Excel	1	11-20-2013 10:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:19 AM.